vlookup

[David cArolla]

Is there a option in Access to do the equivalnet of the
VLOOKUP command in Excel? I've got two files, 500,000
records in each one that I need to compare and match.

Thanks

 

[Douglas J. Steele]

Excel and Access are very different products. It'll help you a lot if you
recognize that up front, so that you don't keep looking for equivalents.

To compare two tables, use queries. When you go to create a new query, one
of the options is the Find Unmatched Query Wizard. Use that to find what's
in table A that isn't in table B, and again to find what's in table B that
isn't in table A.