View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default memory issue using ADO to query Excel

Hi Jamie,

make sure that you set _all_ objects to nothing when you finished your

code!
Esp. the connection string.


Any particular reason for this advice?


run queries eg. in a loop and never cleanup. each query will take longer and
longer and the memory usage of excel (task manager) will grow and grow.

impeccably.

sorry, I do not know this word. anyway: do not clean up = wait.

arno