View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jeroen
 
Posts: n/a
Default vlookup and Access Database Table

The vlookup function itself is an Excel function and as such can only
retrieve data from an excel sheet.
However you may be able to use the import external data menu option in the
Data menu to retrieve your data from the access database, pull it into your
excel workbook and then use the vlookup function. I never tried this myself,
but maybe the idea can be applied.

--
Jeroen van Nieuwkerk




"finster26" wrote:

Can vlookup be used to get a result from an Access Database Table?

Thanks.