Re: memory issue using ADO to query Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 04:08:30 -0400

don't know if this is your situation, but you might check this out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;319998&Product=xlw
BUG: Memory Leak Occurs When You Query an Open Excel Work*** Using ADO 

-- 
Regards,
Tom Ogilvy
"Dennis" <dennisbrininger@comcast.net> wrote in message
news:1cc5e01c45351$945b3c00$a301280a@phx.gbl...
> 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
Quantcast