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
|