View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_34_] Bob[_34_] is offline
external usenet poster
 
Posts: 1
Default Read / compare MS Access data in excel


I have a spreadsheet that contains a part number,
description, and price for parts. Essentially it's a
customer quote.

In an MS Access database ( which has 78K rows, too large
to import into excel ) resides the same information, but
along with it an "internal" part number.

What I need to do is this : read the list of part numbers
in excel, look them up in the database, and return me
the "internal" part number, placing it in a column next to
the "external" part number in the spreadsheet.

Something like a vlookup command but from a Access
database instead of another spreadsheet. Any ideas ?

Bob