I have an Excel file with 8 different sheets. Each sheet is related to a specific table in the database. I need to bring the data in via VBA. I made saved imports for each sheet thinking I would be able to use them (like you can with the TransferText) but I do not see a way to call the import name in the TransferSpreadsheet method.
The code needs to be set up so the user can select the Excel file then the 8 imports will run. The amount of data on each sheet will vary every time so I don't think named ranges would be a practical way of handling it. Just for a bit more background, this process sets up a new backend database, links to the new db, then the spreadsheet import will bring in user developed startup data (ie user table, labor codes table,....)
Am I just missing something in the TransferSpreadsheet method?
In Summary: I need to provide the Excel file (path and name) then run an import for each of the 8 sheets into 8 different tables.
Any help is greatly appreciated.