De-Duping

[Always Learning]

Hi Guys,

Can someone help me with this.
I have 2 files, for simplicity sake File1 & File2

How do I dedupe the files so that no records in file2 exists in file1 and no
records in file1 exists in file2. If any matches are found put them into a
new file and delete them from either file1 or file2 but not from both.
Match on fields, Surname, Add1 & Postcode.
I hope this makes sense.


Thanks for your help,


Steve Wilson.

 

[Lynn Trapp]

Are these MS Access files?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Always Learning]

Hi Lynn,
Thanks for the reply.

They have been imported in from Excel files.

Best Regards,

Steve Wilson.

 

[Roger Carlson]

There may be a better way to do what you are trying to do. Exactly what ARE
you trying to accomplish by this?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Always Learning]

Hi Roger,
Thanks for the reply.
I am trying to get a table of records that are not duplicated. Any
duplicates found I want to put into a seperate table.
So If file1 contains:
Steve Wilson
Dora Explorer
Dan Mangle

& File2 contains:
David Doink
Bob Dazzle
Steve Wilson

"Steve Wilson" will be left in file1 but removed from file2 and put into a
new file called duplitable.

Thanks for your help,

Steve Wilson.

 

[Roger Carlson]

I guess what I'm asking is WHY you want to do it this way. What do you
ultimately want to accomplish? If it's just to create a single table with
non-duplicated data, there are easier ways. I don't want to answer your
specific question if a different answer would give you a better solution to
your problem.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L