Text matching between two tables

[Rakesh935]

Hello Masters,

Requesting to please help me for the below mentioned requirement since I don't have any idea how to proceed further:

Well, I have two tables in an access file one table having customer data base along with the customer name and another table only having the customer name. Now the table having only customer name need not be having the exact customer name in terms of spelling or spaces but both of them will same for e.g. table 1 - Apple and in table 2 - app let. Therefore the system should match this and throw out the results into a different new table as matching results.

Hence, please guide me with the vba code if this is possible. Somebody also told me that this is a kind of percentage matching and unfortunately, I am also not aware of this concept. Once again please help me with this requirement.

Thanks in advance,
Rakesh

 

[billmeye]

Take a look at this.

http://www.utteraccess.com/forum/Advance-Searching-Big-D-t2004789.html

 

[Rakesh935]

Hi billmeye,

Many thanks for the support...

But honestly its really difficult to understand the code which is available in the link you provided.

Requesting if you could possibly explain me few things about the code like e.g. which are the table names refered in the code, where this code needs to get executed, etc...

Thank you,
Rakesh