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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Database Schema help 2
redesign/reassign key that links dependent tables 8
Almost identical sub tables 7
Merge 2 identical databases together 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Autonumber preservation 4
acnewrec? 1

Back
Top