Speed this up?

Ive got some SQL that will be dumping large amounts of data out to CSV files for excel to open

currently I have it looping through each line and dumping it into the CSV. is there a way to get ALL the results from the SQL into one string without having to loop through?

EX:

SQL = "Select FName ||','|| LName from Customers"

[open RS here]
[Open CSV file]

Do while No Rs.EOF
Print #1, rs.fileds(0).value
loop

etc.
etc.

is there a command or something that has ALL the data without having to use the Do While?

thnx

Have you tried rs.GetString ?

It should do what you are after.

ok tried playing with it..cant seem to get it to work right?

How do you use it?

what about .getrows? ever try that?

GetString is the one you want.

How is your data stored in the recordset and how do you want it to be formatted?

Data is a Single field (comma seperated) its going to be dumped to a .CSV file for Excel to open.

I tried the get rows....then I can dump each line in a for next loop seems to be faster then going directly from the RS.


Unless I can grab all at once (with getstring) and split every 1000 lines?

0 - 1000 into first file
1001 - 2000 into 2nd etc...

thanx S@NSIS