> Hi, I use ASP code to generate report that I retrieve about 100,000 to
> 800,000 records from database using ADODB.Recordset. But when i run the
> code, it show me the following error.Sometimes it wont show me this
> error and it can be run. But if the records near 800,000 then program
> show me the following error. If the records is about 100,000 sometimes
> it can be run correctly.
>
> Provider error '8007000e'
> Not enough storage is available to complete this operation.
> /e-survey/progress3.asp, line 192

Dayron <khar_wei_khok@devdex.com> wrote in message news:<uoPlhImjEHA.2500@TK2MSFTNGP15.phx.gbl>...
> Hi, I use ASP code to generate report that I retrieve about 100,000 to
> 800,000 records from database using ADODB.Recordset. But when i run the
> code, it show me the following error.Sometimes it wont show me this
> error and it can be run. But if the records near 800,000 then program
> show me the following error. If the records is about 100,000 sometimes
> it can be run correctly.
>
> Provider error '8007000e'
> Not enough storage is available to complete this operation.
> /e-survey/progress3.asp, line 192
>
>
> Here is my code:
> L188: Set rst = server.CreateObject("ADODB.RecordSet")
> L189: rst.Open strSQL, connection, 3, 3
>
> L191: iProcessedSoFar = 0
>
> L192: If Not rst.EOF Then
> L193: arrRecords = rst.GetRows
> L194: iTotalRecords = Ubound(arrRecords,2) + 1
> L195: rst.MoveFirst
> L196: End If
>
> Another question here is I'm using scripting.FileSystemObject to write
> the data into the excel file. I manage to write all the data into the
> excel file but the excel worksheet just manage to write until 65535
> records and I couldnt write the data anymore. I wish to write the data
> into a few worksheet. can i know how to write the data into different
> worksheet in a workbook?
>
> I hope to get this solution asap as this is the last week issues not yet
> resolved.
>
> Thank you.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***