don't know if this is your situation, but you might check this out:
http://support.microsoft.com/default...98&Product=xlw
BUG: Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO
--
Regards,
Tom Ogilvy
"Dennis" wrote in message
...
I set up a SQL text box to run queries on a 38k rows by
100 columns using ADO. I've got to working fine.
However, after about 10 query requests, I receive
insufficient memory errors and I'm forced to shut down
Excel. I clear my recordset variable after each query. I
was wondering if there is some cache that should be
cleared. All of my queries are SELECT queries.
Any thoughts? Dennis