Re: memory issue using ADO to query Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: arno (schoblochr_at_azoppoth.at)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 09:34:58 +0200

Hi dennis,

> I clear my recordset variable after each query. I

make sure that you set _all_ objects to nothing when you finished your code!
Esp. the connection string.

If you have many queries with one connection string then make sure that you
open the connection only once, run your queries and close the connection.
This is a lot faster the open-query-close-open-query-close...

After a while and lots of queries your Excel will be slow and using a lot of
memory anyway. However, you can work much longer without troubles when you
do what I mentioned.

regards

arno

Quantcast