How to Match Company Names

[niladri20052006]

Hi all,

I have unique contact list in Access consisting of 6,00,000 data where I have info but not the contact details. In another table I have the contact names. Only one thing that is matching between these two tables is Company Name. But the problem is in 6,00,000 table I have the full company Name (Like Zinfi Technologies,Inc) and in contact names table I have the company names but not in full (Like Zinfi Techno...). In that how will I match the companies?

Is it possible to do it in excel part by part?

Thanks in advance!

 

[alansidman]

Here is a thread with some solutions that you may find helpful

http://www.mrexcel.com/forum/showthread.php?t=258713&highlight=Fuzzy+Match

Alan

 

[niladri20052006]

Hi Alan,

Thanks for your reply.

But I am confused. Is there any better way or query?

 

[jackd]

Alan gave you a link. And in the posts at that link was a reference to an Access fuzzy approach.
http://www.codeguru.com/vb/gen/vb_misc/tips/article.php/c13137__1/Fuzzy-Matching-Demo-in-Access.htm

Did you look at it?

Perhaps you could give us a brief overview of how you would approach the problem. And how the fuzzy logic will help.

Good luck with whatever approach you take.

 

[Joe4]

But I am confused. Is there any better way or query?

Not really, not without fixing/standardizing the data!

The whole concept of "relational" database programs like Access is to have common fields in your various table that you can link on. If you do not have that, you really do not have the makings of a good relational database.

 

[Joe4]

Since this is a cross-post of sorts, you should provide a link to your question over in the Excel forum: http://www.mrexcel.com/forum/showthread.php?p=2643265&posted=1#post2643265