Converting Recordset to CSV

[Michael]

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

Thanks for any help

[Bob Barrows [MVP]]

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 FileSystemObjec t 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 FileSystemObjec t.

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"

[Jon Paal]

Re: Converting Recordset to CSV

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

"Michael" <michael.groysm an@intergraph.c omwrote in message news:uJK0Q5LLHH A.3668@TK2MSFTN GP02.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
>