VLOOKUP to tables in MS Access?

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
 
J

Jamie Collins

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.

--
 
Top