Help me, how to match record from tabel A and tabel B
my case:
1.Tabel A contain word like : computer, to, class etc in each record
2.Tabel B contain stop word like : and, to, i etc in each record
3.I want search each record in tabel A and match it with word in tabel B and delete word from tabel A
example:
word to in tabel A same with word to in tabel B,so word to tabel A will be delete

Please Help :D

For each record in A
Retrive the contents of the current A.
Split() is into an array arrA.
For each B
    Retreive the contents of the current B
    Split() is into an array arrB
    For each element of arrA, look for a match in arrB
    If there's a match take action
Next B

Next A

You can compare each element of arrA abainst all of the current B with InStr(). If there is no match to that, there will be no match to anything you would wind up with search an array created with a Split() of B.

You just need to do a brute-force search.