Identifying dups in 2 databases

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

Guest

Hi all,
My task is to identify duplicate records in 2 tables that each located in
different Access database. These tables have exactly the same structure. My
immediate solution is to create two datasets from each table and loop
through one and compare it with another one, but I'm sure there are better
way to this.
Any suggestions is appreciated.
Roy
 
try query wizard - query, new, one of the options is find duplicates, which
will design the query for you.
 
further to my early, if you do not have one, create a link from one dbs to
the other to get the table. From either dbs, try file get external data, link
tables (or import tables) and pick the file, then use the query wizrd
 
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

Eliminating Dups??? 1
How to identify duplicate records in 2 databases 1
Delete all but first dup 1
Help - How to join two datasets 6
mark duplicates 6
Delete many dublicate records from one table 1
Delete Dups Query Failing 3
Dups and Conditional Formating 2

Back
Top