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
 
Back
Top