Import Database from Mult-Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learning_codes@hotmail.com - 04 May 2008 17:00 GMT

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

Reply to this Message

Damon Heron - 04 May 2008 20:53 GMT

When you import a table with the same name as an existing table, Access adds
a number to the name. If there is no duplicate data in the multiple tables,
you can probably use an append query to add all the data1,data2,etc. tables
to the first table. Note that you can't append the primary key, usually an
autonumber, but you can append all the other fields.

Damon

> Hi,
>
[quoted text clipped - 17 lines]
> Data1
> Data2

Reply to this Message