Duplicates & Append

  • Thread starter Thread starter P Brainard via AccessMonster.com
  • Start date Start date
P

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
 
P Brainard via AccessMonster.com said:
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
Click to expand...

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.
 
Back
Top