Exporting & Importing

  • Thread starter Thread starter skk
  • Start date Start date
S

skk

Hello All,

I have two of the same DB. A person made a copy (DB1 & DB1copy) and started
adding to the DB1copy while others added to DB1. How can I add (import) only
the new record from DB1copy into DB1 without duplicating pervious record????


Thank you for any and all help.
 
Hi,
how many records are we talking about here?
how many tables are involved?
do you have any unique combination of fields that you use an an index on any
of the tables involved?


Jeanette Cunningham
 
In my DB1 I have 540 records and in DB1copy I have 800 records. I have 8
tables with only one having a PK.
 
skk,
from your description, there are no relationships between the tables.
If that is right, then start with any table.
Import it into DB1.
Use the find duplicates query wizard.
In A2000 - A2003, on the menu | Insert | query | Find duplicates

Continue with the other tables.


Jeanette Cunningham
 
You must log in or register to reply here.

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

Importing/exporting/linking in Access 2002 1
Referential Integrity on Linked Tables 3
Importing from Distributable Database 1
Linking Tables from Password Protected DB 2
Appending Records from Table to Table 1
Compact and Repair Error 2
Automatic database import between Access 2003 dbs 2
Importing Data - Access 97 8

Back
Top