How to merge identical tables

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

 

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

 

[davsch100]

Jeff,

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

Dave