Newbie here...hoping someone can point me in the right direction. I currrently use MSAccess 2003.
Does anyone know of a possible add-on tool for de-duping that is more
detailed than just the 'find duplicates' wizard in Access. More
specifically, what I am looking for (or asked to do at work), is something
that will pick up a duplicate record in the database in which the fields
arent 'exact'. (ie, a company name of one of the records says Brigham Young
University with an address line of P.O. Box 882, and the other record is BYU
for company, and PO Box 822)..these arent EXACT obviously, but is most likely
the same person(with a possible typo in the PO Box). Unfortunately, there
are no unique identifiers for this table.
Any help or advice would be greatly appreciated...even if it involves using
a completely different database program.