Duplicates & Append

[P Brainard via AccessMonster.com]

I have a database of about 150,000 records w/names, addresses, and various
other data. I want to strip out all likely duplicates by matching whole
and/or partial field data. Then I'd like to append those like duplicates
into another table so I can review them. I don't want to delete them from
the original table until I've verified them in the new table.

I'm a seriously query idiot, and my find dupes query isn't installed on my
PC. I'm using Access 2002 on XP.

Thanks,

Paul

 

[Chris2]

I have a database of about 150,000 records w/names, addresses, and various
other data. I want to strip out all likely duplicates by matching whole
and/or partial field data. Then I'd like to append those like duplicates
into another table so I can review them. I don't want to delete them from
the original table until I've verified them in the new table.

I'm a seriously query idiot, and my find dupes query isn't installed on my
PC. I'm using Access 2002 on XP.

Thanks,

Paul

Paul,

This project isn't as easy as it sounds. Your best bet will be to
look up the SOUNDEX algorithm and any pattern matching code you can
find.

Try searching for "Minimum Edit Distance" and "string matching",
though it isn't for the faint of heart.

Good luck.


Sincerely,

Chris O.