vlookup function in excel referencing an access table

[Guest]

I canot store the lookup data in excel, it exceeds the 65 thousand row limit
set by the program. Is there a way to use the vlookup formula referencing an
access db table?

 

[Frank Kabel]

Hi
in this case (if you have to use Excel) us ADO (within VBA) or import a
query result from Access directly.
you can't use VLOOKUP in combination with an Access database.

You may also have a look at the following site:
http://www.bygsoftware.com/examples/sql.html