Starter for ten required for a bit of code to match two separate data files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Sultan - 07 Dec 2006 11:42 GMT

I am looking to develop a bit of code/algorhithim which can
compare/match two tables of data- essentially a tool to spot cross
matches between two different lists. Both tables contain the following
fields

Name
Address1
Address2
Address3
Address4
Address5
Postcode

The idea being that I can put two separate lists of companies through
the code and know which companies appear on both - albeit calculated to
a certain degree of probability
Simply linking the fields in a straightforward query does not work
becuase you have situations where spelling mistakes pop up,
abbreviations versus full word (ltd v limited) etc etc

At this stage I am looking for a suggestion to start me off

Reply to this Message

Alex Dybenko - 07 Dec 2006 12:53 GMT

Hi,
in this case you still can use a query, but have to use a function like
Soundex() to compare fields with spelling mistakes etc.

function you can find here:
http://www.freevbcode.com/ShowCode.Asp?ID=1136

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I am looking to develop a bit of code/algorhithim which can
> compare/match two tables of data- essentially a tool to spot cross
[quoted text clipped - 17 lines]
>
> At this stage I am looking for a suggestion to start me off

Reply to this Message

Keith Wilby - 07 Dec 2006 12:57 GMT

Just off the top of my head, have you tried unioning the tables in a query
and then running a "find duplicates" query on the union? Never tried it but
it might work.

Keith.
www.keithwilby.com

Reply to this Message