Data Import

To import data contained in Comma Separate Value (CSV) files into one or more SQL database tables. Script must be ASP, VBScript and/Javascript and fully documented. ## Deliverables Provide a combined set of full documented, completed, tested and working scripts / markup which will: 1. Allow the user to specify a CSV file, containing header row, followed by data rows 2. Open the CSV file and check 3. Present the original rows of data to be imported from the CSV file as a table 4. Allow the user to select all or specified rows of data to be imported 5. Connect the specified database(s) which can be MS-Access, SQL-Server or mySQL. 6. Ensure data does not already exist in the target database and table(s) 7. Ensure data is imported to the specified table(s) 8. Ensure data is imported only once 9. Close database connection(s) 10. Present data rows that could not be imported, together with a descriptive reason for each item that could not be imported as a table 11. Present the total rows of data that have been successfully imported as a table The import scripts must work for each of the databases above. Active Server Page (ASP), Visual Basic (VB), Javascript / JQuery, CSS, HTML only. NO JAVA code. Several test CSV files can be provided if required