Speed this up? (SQL & a CSV)
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
