This is a very simple access database which requires a new form which will allow the user to select/deselect which excel spreadsheets they would like to import, and error checking. This should be a very easy job for an experienced programmer. Excel files consist of several spreadsheets (10+), some with different formats. Error checking needs to be added to compensate for these variables. Thank you for your bid.
## Deliverables
Requirements:
When the user selects either the "Import Old Project Data", or "Import New Project Data" buttons the current code opens a "select file" message box allowing the user to select an MS Excel file, once the file is selected all spreadsheets in the excel file are imported.
1. The modification to this code will; when the excel file is selected, the application will provide a new popup "Form" with a list of all the spreadsheets in the excel file. The list will contain checkboxes which will allow the user to select/deselect which spreadsheets they want to import.
2. Also, at this time the system will determine if the file setup of all of the excel spreadsheets matches the fields in the database. If a new field is found, the application will prompt the user with a message box stating the new field was found, and tell the user in which spreadsheet this new field was found.
3. The application will then prompt the user and ask whether the application should continue or Cancel to import the spreadsheets without the new field.