Using ADO and a UDF you could do it, like this for example:

http://mrexcel.com/board2/viewtopic....cess+vl ookup

--
Regards,

Juan Pablo González
Excel MVP

"maacmaac" wrote in
message ...

I want to use a vlookup type function to access data in Access. I am
unable to export the information to Excel because it is 180,000 rows.
Example: If the data in cell A1 is a Social Security Number, I want to
be able to access a name associated with this number in access. Is
this possible?

Thanks in advance for any comments.


--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile:
http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=465784