Maybe try an instr() search for each word of T1 in T2, count the matches, and choose the highest number? Three nested loops should do: one for T2, one for T1, and one for the words per row of T1.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Allem Beyene Sent: Friday, September 21, 2007 1:07 PM To: [email protected] Subject: [Access VBA Central] partila string match hi guys this is the problem i'm facing, i have 2 tables with more than 50000 rows of data. i need to make a partial string match comparison( if possible % match). example Table 1 Item# Model Desc ------------ --------- -------- 001 Corola toyota 002 Camry toyota 003 Tundra Toyota 004 Avalon Toyota table 2 Item# Desc ------------ --------- -------- 011 Toyota Camry is a japanese Auto 012 good mpg for corola 013 Copeting against US trucs - Tundra 014 Preimium brand Avalon the function should compare the "model" field from the first table against the "desc" field for a partila string and detrmines which row best matches help Thanks [Non-text portions of this message have been removed] Yahoo! Groups Links
