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


--
Regards
Frank Kabel
Frankfurt, Germany


AJN wrote:
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?