You can use GetString method of recordset object to convert recordset (SQL query) to csv file :
for 'Download recordset as a CSV (DBF, MDB) file' articleASP/VBS, ADO and DBF file database connection.Short introduction to work with DBF files/databases in ASP/VBS/WSH envinronment. Work with DBF using Microsoft.Jet.OLEDB.4.0 provider.
Copyright and use this code
The source code on this page and other samples at http://www.motobit.com/tips/ are a free code, you can use it as you want: copy it, modify it, use it in your products, ...
If you use this code, please:
1. Leave the author note in the source.
2. Link this sample from you page.
<A Href="http://www.motobit.com/tips/detpg_RSConvert/" Title="Enables download data from recordset (or SQL query) as csv (DBF, MDB file)." >Download recordset as a CSV (DBF, MDB) file</A>
© 1996 - 2014 Antonin Foller, Motobit Software | About, Contacts | (Find us on Google+)