VLOOKUP to tables in MS Access?

Is it possible to do a VLOOKUP directly to an Access table instead of
copying the data table into an Excel worksheet? If so can I reference
the Access table for both arguments 2 & 3 in the VLOOKUP formula?


--
Flamikey
------------------------------------------------------------------------
Flamikey's Profile: http://www.excelforum.com/member.php...fo&userid=4612
View this thread: http://www.excelforum.com/showthread...hreadid=264857

Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

"Flamikey" schrieb im
Newsbeitrag ...

Is it possible to do a VLOOKUP directly to an Access table instead of
copying the data table into an Excel worksheet? If so can I
reference
the Access table for both arguments 2 & 3 in the VLOOKUP formula?


--
Flamikey
---------------------------------------------------------------------
---
Flamikey's Profile:
http://www.excelforum.com/member.php...fo&userid=4612
View this thread:
http://www.excelforum.com/showthread...hreadid=264857

Flamikey wrote ...

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.

--