breilly192
Technical User
I have 100 or so like tables I was able to import into an Access mdb from Excel files. Now, I need to copy all of these individual tables into one - fields are the same in each table. I guess I should have imported them from files into one table, but that is beside the point.
Can a DoCmd.TransferSpreadsheet or DoCmdCopyObject efficiently copy all the data tables into one new table via a Do While loop or is a SQL statement better? I would have thought an insert or append query but didn't know how to code to vary the source tables within the mdb.
Any help would be appreciated.
Can a DoCmd.TransferSpreadsheet or DoCmdCopyObject efficiently copy all the data tables into one new table via a Do While loop or is a SQL statement better? I would have thought an insert or append query but didn't know how to code to vary the source tables within the mdb.
Any help would be appreciated.