Data Dudup and Matching - Software / Functions

[Jado]

Hi

does anyone know of VB/VBA code to dedup data in an Access database?

or,and, to match data in 2 different tables based on exact or close match?

is there any free software available?

can anyone recommend any non-free software?

also any resource on how to dedup and match would be great!

Thanks

Jado

 

[Lance McGonigal]

Boy...There are a number of ways to do this. Could be as simple as a
summary query with a table reload to some very complex services such as
Acxiom's AbiliTec.

As far as the match goes, you could use SoundEx and loosen the number of
characters that are used to develop the key. I have that code if you'd
like.

Blessings

 

[Jado]

Hi Lance

what i need is something that can do this:

A.B.C Components Ltd + abc components = Match

abc compoasnts ltd + ABC Components Limited = Match
--------------------------------------------------------

Where is your code from?

if it's the example in VB Source Book, then i have that already!

Thanks

Jado