ASP classic recordet error "8007000e" Out of memory

I have a script that exports a recordset to excel. My recordset has 139 columns. I can see in the fiddler that the excel table header is being created, but when it comes to writing the values, I run into this error:

Microsoft Cursor Engine error '8007000e'

Not enough memory.

/includes/ExportFunctions.inc, line 49

when i remove 5 columns then it works well enough, even null columns! This is so strange to me because I cannot find any constraints on recordsets and I am sure I have selected all the objects I need. Here is my code:

Response.Write "<table>" & vbCrLf
Response.Write "<tr>" & vbCrLf
For intItem = 0 To rstResult.Fields.count - 1
    Response.Write "<th>" & rstResult(intItem).Name & "</th>" & vbCrLf
Next    
Response.Write "</tr>" & vbCrLf
dim index 
index = 0 
Do While Not rstResult.EOF
    Response.Write "<tr>" & vbCrLf
    For intItem = 0 To rstResult.Fields.count - 1
        Response.Write "<td><nobr>"
        If IsNull(rstResult(intItem).Value) Then
            Response.Write " "
        else
            Response.Write rstResult(intItem).Value
        end if
        Response.Write "</nobr></td>" & vbCrLf
    Next    
    Response.Write "</tr>" & vbCrLf

    Response.Flush

    rstResult.MoveNext
LOOP

      

        
        
        
      

    

The error refers to line 49, which is

Do While Not rstResult.EOF

      

        
        
        
      

    

Does anyone have any ideas about this?