Compare Two Tables & Show Dups.

fenhow

Registered User.
Local time
Today, 15:02
Joined
Jul 21, 2004
Messages
599
Hi,

I have two text files each containing data.

I want to import the text file data into seperate tables say, data1 and data2 then bounce them for dups.

At the end a simple report that shows the matches found.

Has anyone seen such a db already working? An example would be much appreciated.

Thanks.

Fen
 
Hi,

I have two text files each containing data.

I want to import the text file data into seperate tables say, data1 and data2 then bounce them for dups.

At the end a simple report that shows the matches found.

Has anyone seen such a db already working? An example would be much appreciated.

Thanks.

Fen

You can import your data into separate tables, and create a query using the Find Duplicates Query Wizard. That will probably give you what you are looking for. Note that there is also a Find Unmatched Query Wizard to show the differences.
 
I think that the find duplicates query wizard is looking for duplicates in a table not across 2. But if you join both tables on all fields then only duplicates will be selected. Of course if you have duplicates in one of the tables that will cause records to be multi selected.

Brian
 
Thanks, the find duplicate wizard only gives me an option to search one table for dups. I want to bounce table2 against table1 and obtain the results. Should I merge both text fields into one table?

Thanks.

Fen
 
I think that the find duplicates query wizard is looking for duplicates in a table not across 2. But if you join both tables on all fields then only duplicates will be selected. Of course if you have duplicates in one of the tables that will cause records to be multi selected.

Brian


You guys are right about the Duplicate Query Wizard. I thought it worked like the Unmatched Query Wizard, which compares values contained in two tables. Brian is correct about what to do. You also might want to make sure the join is an INNER JOIN so that only records with matches are selected
 
Got it, thanks for everyones help.

Innerjoin query shows matches.

Fen
 

Users who are viewing this thread

Back
Top Bottom