Identifying dups in 2 databases

R

Roy

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
 
E

eddybarzoom

try query wizard - query, new, one of the options is find duplicates, which
will design the query for you.
 
E

eddybarzoom

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
 
Top