I am trying to find a quick way to load up my access database with new tables created from multiple excel sheets.
I have 160 sheets with headers that I want to import into Access from Excel using the sheet name as the name of the access table name. Use the first row in each tab as the field names inside the table and the second row in the sheet to define the field type.
Well they will all be number format so that last part can be hard coded in.
I tried following some other mentions of creating tables via excel but I am a bit stumped.
I have code that I have used before for uploading data from excel into specified tables but I cannot figure out how to create new tables. Driving me crazy.
As I will be uploading an additional 200 sheets into another database, I would rather not have to do each of these manually.
I am using Excel & Access 2007
I have 160 sheets with headers that I want to import into Access from Excel using the sheet name as the name of the access table name. Use the first row in each tab as the field names inside the table and the second row in the sheet to define the field type.
Well they will all be number format so that last part can be hard coded in.
I tried following some other mentions of creating tables via excel but I am a bit stumped.
I have code that I have used before for uploading data from excel into specified tables but I cannot figure out how to create new tables. Driving me crazy.
As I will be uploading an additional 200 sheets into another database, I would rather not have to do each of these manually.
I am using Excel & Access 2007
