Import one 03 database into another 03 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would to import one 03 database into another 03 database and apend the data
into each existing table. I useing Access 2007

I tried the import function however it imported each table into the database
as a "new" table. That is the original table named tblcourse now I have two
tables the second named tblcourse1. I wanted the data to be apened to the
first table.

Any way to do this?
Thanks
 
From database 1, link to the table in database 2. Then, write an Append
query to take the data from the linked table and add it to the existing
table. Once you've done that, you can delete the linked table in database 1.
(Don't worry: it won't affect the table in database 2)
 
Back
Top