Background
The DB load is for an Online Exam Simulator. The maintenance of the questions will be done in a Excel spreadsheet as the author of the questions may work from areas that do not have internet connection. Excel Spreadsheet could be saved in another format text, xml etc whatever is available from the "Save As" function in Excel. You let us know what the preferred format would be.
Requirements
A script to load in data from a data file into a MySQL database.
It should be possible to initiate the load script from a web form selecting what file to load into the database.
User to select from a dropdown what code the questions in the spreadsheet should be loaded under.
The script should dump the data for the specified code from the database before loading the data from the file.
Details about the database structure and file structure will be forwarded to the winning bid.