469,914 Members | 2,501 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,914 developers. It's quick & easy.

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
Dec 31 '06 #1
2 3172
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"
Dec 31 '06 #2
http://www.veign.com/vrc_codeview.asp?type=web&id=40

"Michael" <mi**************@intergraph.comwrote in message news:uJ**************@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

Dec 31 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Marathoner | last post: by
32 posts views Thread by robert d via AccessMonster.com | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.