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