I'm using
sDelimiter = ""","""
rDelimiter = chr(34) & vbCrLf & chr(34)
CSVhead = ""
CSVhead = "LIST OF FIELD NAMES"
CSV = objRS.GetString(,, sDelimiter, rDelimiter, "")
response.write CSVhead & chr(34) & CSV & chr(34)
to generate csv files. Testing has now revealed that it goes pearshaped on very large recordsets.
"Not enough storage is available to complete this operation" is the error message
the recordset had 1.5 million records in it. 10,000 records in my csv file is about 1 meg.
Is there a simple way of breaking the file down into managable chunks and export say 250,000 into the csv file at a time? or a different way of generating my csv file that can cope with these file sizes.
If we do it through DTS then its fine, slow but fine.
the ASP pages and sql database are stored on the same PC (XP Pro at the moment)
cheers
Andy
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Well... you almost got that part :)
Look at the definition of Getstring:
string = recordsetobject.GetString (StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr)
You can specify the Number of rows you want to get :)
But what you really want to look into is paging, like you say, split it up into small chunks. Take a look at these URLS:
http://www.vbdotnetheaven.
http://msdn.microsoft.com/
http://msdn.microsoft.com/
Business Accounts
Answer for Membership
by: amit_gPosted on 2005-05-20 at 13:30:21ID: 14048804
Try 2 things...
1) Set Response.Buffer = False at top of the page.
2) Use this sub
Call RecordsetToCSV(objRs)
sub RecordsetToCSV(ByRef oRs)
dim oField, bFirst
call oRs.MoveFirst()
if oRs.EOF then
return
end if
bFirst = true
for each oField in oRs.Fields
if (bFirst) then
call Response.Write("""" & oField.name & """")
bFirst = false
else
call Response.Write(",""" & oField.name & """")
end if
next
call Response.Write(vbCrLf)
while not oRs.EOF
bFirst = true
for each oField in oRs.Fields
if (bFirst) then
call Response.Write("""" & oField.value & """")
bFirst = false
else
call Response.Write(",""" & oField.value & """")
end if
next
call Response.Write(vbCrLf)
call oRs.MoveNext()
wend
end sub
This will be very slow for your case as the number of records is very very high to be done this way. You should be using DTS for this.