Re: memory issue using ADO to query Excel
From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 06/16/04
- Next message: Wandering mage: "Cycling through the cells in a range"
- Previous message: Hardy: "For Each...Next statement"
- In reply to: arno: "Re: memory issue using ADO to query Excel"
- Next in thread: arno: "Re: memory issue using ADO to query Excel"
- Reply: arno: "Re: memory issue using ADO to query Excel"
- Messages sorted by: [ date ] [ thread ]
Date: 16 Jun 2004 08:08:57 -0700
"arno" wrote ...
> make sure that you set _all_ objects to nothing when you finished your code!
> Esp. the connection string.
Any particular reason for this advice? My experience is that if you
let the objects go out of scope, ADO cleans up impeccably.
Jamie.
--
- Next message: Wandering mage: "Cycling through the cells in a range"
- Previous message: Hardy: "For Each...Next statement"
- In reply to: arno: "Re: memory issue using ADO to query Excel"
- Next in thread: arno: "Re: memory issue using ADO to query Excel"
- Reply: arno: "Re: memory issue using ADO to query Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
