How to merge identical tables

D

davsch100

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.
 
J

Jeff Boyce

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>
 
D

davsch100

Jeff,

Thank you! I got it.
I am a bit green to Access, I appreciate your help.

Dave
 
Top