The data I have in Access has about 130,000 lines of. Excel will only handle
65,000 lines. Is there any other way to do this?

"Chip Pearson" wrote:

You can't point a VLOOKUP to Access. You'd have to write code or
use a query table to bring the data into Excel and uses that
range in VLOOKUP.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dford" wrote in message
...
I would like to link data in Access to cells in Excel using
VLOOKUP. How
would this be done?