How to merge identical tables

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

Guest

Access 2000

I have two seperate db's each with tables that are identical. How do I
import all of the records from one to the other?

I try the Import utility and it tells me the table is in use by myself or
another user. (No other users)

Any help is appreciated.
 
Open one .mdb file. Link to the other .mdb file's table. Both tables now
"appear" in the same database. Use an append query to copy records from one
to the other.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top