how to generate the result in a text file?

External Since: Sep 16, 2004 Posts: 1

I know how to get data from the database, but how to put the result to a text
file (.csv)? The idea is when the user clicks the 'result' button, it should
generate a .csv file with the query result. Thanks!

External Since: Feb 04, 2004 Posts: 123

ADO Recordset Export Class (CSV, HTML, Excel)
<a rel="nofollow" style='text-decoration: none;' href="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=58842" target="_blank">http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txt...eId=588</a>

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
<a rel="nofollow" style='text-decoration: none;' href="http://www.veign.com/vrc_main.asp" target="_blank">http://www.veign.com/vrc_main.asp</a>
--

"Kate" wrote in message

> I know how to get data from the database, but how to put the result to a
text
> file (.csv)? The idea is when the user clicks the 'result' button, it
should
> generate a .csv file with the query result. Thanks!