Import Database from Mult-Tables
Hi,
I'm trying to import many tables from many database into one Access
Database to make one table.
Is there a way to import into one table from many tables?
Your help would be much appreciated.
Here is the sample code:
DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\db1.mdb",
acTable, "Table1", "Data", False
DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\db2.mdb",
acTable, "Table1", "Data", False
The result is that I get
Data (would like to have Data1, Data2 adding to DATA table)
Data1
Data2
|