This is difficult - matching with "Like" between two tables.

[ASG]

I've never come across something like this in 7 years of using Access.



I have two tables in my DB, one(Table A) contains about 10 million long-text records(emails). Second(table B)contains about 20k text values(names). The problem is I need to take out only those email addresses which match the names in Table B. As you know, email address are usually names mixed with other stuff.

Any ideas how to do it?

[ranman256]

Try in a query, load both tables, DO NOT LINK THEM.
pull down the fields needed and under TableB.email criteria, put :
LIKE * & tableA.name & *