Importing from another access db

  • Thread starter Thread starter Randy
  • Start date Start date
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.
 
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.
 
Back
Top