VLOOKUP to tables in MS Access?

[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

 

[Frank Kabel]

Hi
AFAIK this is not possible

 

[Jamie Collins]

Is it possible to do a VLOOKUP directly to an Access table instead of
copying the data table into an Excel worksheet?

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.

--