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

find duplicates between 2 tables

P: n/a
Hi,

I've got an application that imports records from a text file into a
temporary table. I then want to insert from the temp table into a
master table but only records which are not in there already. The data
has no unique fields so to find a duplicate record each field in the
tables would need to be compared. There are 33 fields in the master
table consisting of text, number and date/time. The temp table has the
same fields except that they're all text.

I can think of a few ways to do this but I'm not sure what the fastest
would be, which is very important as the import would be of about
100,000 records each time.

I'd ideally like to compare the temp table to the master table and any
records which do not already exist in the master table be inserted
into a staging table, then insert all from the staging table into the
master table after the compare.

Any and all suggestions welcome!

Regards,

Mong
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
use the Find Unmatched query wizard. Then turn that into an append
query once you have it selecting the right records.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.