I have several Excel spreadsheets that are used for entering data. CUrrently all data is entered in the spreadsheets and the saved as a spreadsheet.
SInce I need to do analysis of the data entered (other spreadsheets are used) and issue reports to c lients, I would prefer to put the data in a database. I know I could recreate the spreadsheets as forms in the database and enter the data that way but the spreadsheets are quite complex and have many columns and lines.
Is it possible to use an Excel spreadsheet for the data collection then click a button and add a record(s) to the database in one or more tables?
What code would be used behind a save button?