I'd use ADO This article may help.

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

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"rirus" wrote:
| Using VBA, I want to query an Access database table which has 240,000
| records. The data I am quering for is from a worksheet (sheet1) and I
would
| like the results stored in an Excel worksheet (sheet2). The results from
the
| query will be only a few thousand records, never greater than 10,000. The
| Access db and Excel sheet are on the same PC. Eventually I will need to
query
| the Access DB from a different PC across a network.
| What is the best way to do this?
|
| Thanks,
|
| rirus