We have files (hundreds of them) with flat data in them stored on Sheets 2, 3, 4, and 5.
We have an access relational database with four tables.
We would like to import the Excel sheets into its respective tables.
The we have to continue with this process for each Excel file, appending the data from the next file/sheet into the proper Access table.
What would be the best way to deal with this data conversion/data loading situation?
Is there a way to automate any of these steps?
We have an access relational database with four tables.
We would like to import the Excel sheets into its respective tables.
The we have to continue with this process for each Excel file, appending the data from the next file/sheet into the proper Access table.
What would be the best way to deal with this data conversion/data loading situation?
Is there a way to automate any of these steps?