By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,365 Members | 2,946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,365 IT Pros & Developers. It's quick & easy.

How to identify duplicate records in 2 databases

P: n/a
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 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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

"Roy" <Ro*@discussions.microsoft.com> escribió en el mensaje
news:14**********************************@microsof t.com...
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.