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