In Progress

Database load from Excel file


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.


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.

Skills: PHP, XML

See more: simulator c++ online, questions of data structure, loading function in php, excel to xml online, excel &, data structure questions, excel database load, load excel background, php excel file load database update insert data, mysql loading file database, excel script load database, database loading excel file, load excel file background, excel load database, load excel file, load excel file database php function, linux script load excel mysql table, load excel database, load excel spreadsheet, loading excel spreadsheet web developer 2008

About the Employer:
( 10 reviews ) Dartmouth, Canada

Project ID: #217045