View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
TK TK is offline
external usenet poster
 
Posts: 177
Default ADO Recordset using Excel as a database. Can't free the memory

Hi Denis


Denis Biland" wrote:


I have 3 sheets of data in an Excel workbook. Those data where prevouisly
imported from an SQL database.


Have you propertly this connection closed ??


I need to perform many filtering opperation on those datas to fill different
tables with the numbers of rows left after the
filter is applied.

After creating a connection object and a recordset, i pass the recordset to
a funtion. Here is a portion of this funtion.


If this is an open wookbook see

http://support.microsoft.com/?kbid=319998


Good Luck
TK