Converting Recordset to CSV

After reviewing the internet I did not find strong and simple example that
transfer recordset to simple CSV file.

Thanks for any help

Re: Converting Recordset to CSV

Michael wrote:
> After reviewing the internet I did not find strong and simple example
> that transfer recordset to simple CSV file.
>
> Thanks for any help
There is no single-step method of doing this. Basically, you create a string
containing the csv data and then use FileSystemObject to write it to a file.

The GetString method is very useful for generating the string. Its default
arguments will result in a csv string:

dim rs, s
s=rs.GetString

ASPFAQ has several examples of using the FileSystemObject.
http://www.aspfaq.com/show.asp?id=2039
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Converting Recordset to CSV

http://www.veign.com/vrc_codeview.asp?type=web&id=40



"Michael" wrote in message news:uJK0Q5LLHHA.3668@TK2MSFTNGP02.phx.gbl...
> After reviewing the internet I did not find strong and simple example that transfer recordset to simple CSV file.
>
> Thanks for any help
>