Importing from another access db

R

Randy

When importing a table from another Access database, is
there a way to import the table DATA only, into an
excisting table? When I try importing from another
access database, it creates a new table instead of adding
to the excisting table.

Any help would be greatly appreciated.
 
C

Cheryl Fischer

Use File|Get External Data|Link to link to the table in the other database.
You can then create an Append Query to add the data from this table to the
existing table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top