Memory leak query

B

Blue Aardvark

I'm using Excel 2002 and querying excel files using ADO. I have read on the
microsoft site that there is a memory leak bug when you query open files, but
could not find any fixes for the problem. (Other than their suggestions of
effectively forming a duplicate copy of the data). Has anyone come up with a
sensible work around for the bug, or found an upgrade (maybe Excel 2003??)
that would help me?

Thanks.
 
B

Blue Aardvark

Hi Jamie,

Thanks for the info. I was led to believe that ADO was microsofts new
wondertoy, but it seems to have some definite issues. I would still like to
use sql to retrieve data from an open excel file as it would save me a lot of
hard coding vba. Do you know any other tricks? Perhaps DAO instead? Otherwise
I may be stuck repeatedly using the saveCopyAs function until my hard disk
burns out.

Steve
 
Top