Pulling data from Access into Excel isn't difficult. Here's a starting point

http://support.microsoft.com/kb/295646

It explains how to pull Access data into Excel using ADO. You don't need to
do lots of coding if your queries are fairly standardized, and you may find
it is much faster than having 60,000+ rows in Excel




"Susan" wrote:

I've got a large database within Excel, and will soon exceed 70,000
rows. Excel's limit, as we know is 65,536
Its used to support VLOOKUP and IF functions, and return prices and
purchasing data for items on another worksheet, which usually contain
1000 items or less.

Short of paring down my database, it there a way to keep the data in MS
Access, and query the lookup answers from within Excel, and have Excel
just display the correct prices and other data pertinant to that line?


Sue