How do I save SQL results to a file?

[SiteMaze 0]

How do I save SQL results to a file?

The SQL returns 1000s of records, do I have to loop through each of them and save line by line? Is there a simpler better method of doing it?

Example: This SQL will retun 20,000 lines and I love to save this into a CSV file.

$sql2 = ObjCreate("ADODB.Recordset")
        $sql2.cursorlocation = 3
        $sql2.open ("Select * From Table_Members", $oConnectionObj)
        If Not $sql2.eof Then
            $t_ret = $sql2.Fields(0).Value & "," & $sql2.Fields(1).Value  & "," & $sql2.Fields(2).Value  & "," & $sql2.Fields(3).Value 
            $ret = $ret & $t_ret & @CRLF
        EndIf
        $sql2.close

[SiteMaze 0]

^bump. The traffic at this forum is so massive that new posts get burried in the 2nd page just after a few hours.

Can someone help me?