VLOOKUP to tables in MS Access?

  • Thread starter Thread starter Flamikey
  • Start date Start date
F

Flamikey

Is it possible to do a VLOOKUP directly to an Access table instead o
copying the data table into an Excel worksheet? If so can I referenc
the Access table for both arguments 2 & 3 in the VLOOKUP formula
 
Flamikey said:
Is it possible to do a VLOOKUP directly to an Access table instead of
copying the data table into an Excel worksheet?
Click to expand...

The closest you can get is using SQL.REQUEST (or other functions in
the odbc add-in - google it) in a cell formula. However, you'll create
one connection per SQL.REQUEST formula, so if you are doing lots of
'lookups' it may be best to get a local copy of the data to operate on
anyhow.

Jamie.

--
 
Back
Top