vlookup

  • Thread starter Thread starter David cArolla
  • Start date Start date
D

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
 
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.
 
Back
Top