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 https://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="https://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>
Do you like it? Rate me on LinkedIn
© 1996 - 2019 Antonin Foller, Motobit Software | About, Contacts