How to identify duplicate records 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 response was 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
 
I am not sure if it works, but if Access supports remote joins (attaching a
table from other database), that would be better.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com
 

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

Help - How to join two datasets 6
Identifying dups in 2 databases 2
Access Compare records in same access table 0
Access Auto Matching Duplicates? 0
Identifying new records 2
How to verify for duplicates before insertion in a dataset? 7
How to Delete duplicate row access 2003 0
Identifying Duplicate Records 8

Back
Top