Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old December 31st, 2006, 09:35 AM
Michael
Guest
 
Posts: n/a
Default 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


  #2  
Old December 31st, 2006, 12:15 PM
Bob Barrows [MVP]
Guest
 
Posts: n/a
Default Re: Converting Recordset to CSV

Michael wrote:
Quote:
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"


  #3  
Old December 31st, 2006, 04:15 PM
Jon Paal
Guest
 
Posts: n/a
Default Re: Converting Recordset to CSV

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



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

 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles