best way to export data from an MsSQL table to a CSV file

[germon]

Hi guys,

Could you please give me a hint which is the best way to export data from an MsSQL table to a CSV file, or any other file

Thank you in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[snedden]

Well for just a run-of-the-mill csv you could always just step through the recordsets and build your own, like this

while not recordset.eof
response.write field1 & ", " & field2 & ", " & field3 & ", " & field4 & ", " & field5 & "<br />" & vbcrlf
recordset.movenext
wend

and either display that to a browser and c/p it if it's a one-off deal or append it to a file if its a regular occurance via the filesystemobject method. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[kasprov]

Related question

what you think of constructing the tables in HTML and then just copy and paste, I think it'll also work -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --