| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
memory issue using ADO to query Excel
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum Number Of Worksheets In A Work Book-Not A Memory Issue???? | Excel Discussion (Misc queries) | |||
| Excel 2003 memory issue | Excel Discussion (Misc queries) | |||
| Memory or power issue | Excel Discussion (Misc queries) | |||
| Charts appear snowy (e.g., tv) unless clicked on. Memory issue? | Charts and Charting in Excel | |||
| Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
Threaded Mode
