How to Import different spreadsheets into a temp table
Posted on 2016-08-18
Within MS Access VBA I want to:
Delete a table including its structure called tempTableDailyImport
Import a spreadsheet into tempTableDailyImport
In short I am looking to load a spreadsheet into a temporary table that will reflect the column names of a spreadsheet. The spreadsheets loaded into this temp table will consistently have different column names with each iteration of the code (will be run on a daily basis), thus I do not want to set up a static table.
Once the data is loaded into this temp table I have code that will read the column name, etc, however I am struggling on low to load data into a non static table on a daily basis.