Import/Append Data

[Arthur]

I want to add (append) data to my existing Access table
(that already contains some data). The data I want to add
is in a table in another Access file. Both tables have the
same name. How do I do this?

Art

 

[Cheryl Fischer]

Using File|Get External Data|Link, link to the table in the other Access
database. Since this table has the same name as a table already in your
database, it will be linked with the numeral 1 added to the table name. So,
if your first table is named MyTable, the linked table with the same name
will be linked as "MyTable1". Then, you can create an Append Query to
append data from MyTable1 into MyTable.