Download recordset as a CSV (DBF, MDB) fileMOTOBIT.COM

Other articles:

Base64 decode VBS function (vb decoder algorithm), source code (http, Conversion, VBScript)

Base64 encode VBS function (vb encoder algorithm), source code (Conversion, VBScript)

Work with binary files in VBSscript - read and write local and remote files (WSH, File & data transfer, Functions, VBScript)

Download multiple files in one http request (File & data transfer, VBScript)

Areas > Languages > VBScript
Areas > ASP / ASP.Net > Functions > Conversion

You can use GetString method of recordset object to convert recordset (SQL query) to csv file :

Dim RS, SQL, Conn
SQL = "Some query ...."
Set RS = Conn.Execute (SQL)

Dim F, Head
For Each F In RS.Fields
  Head = Head & ", " & F.Name
Next
Head = Mid(Head,3) & vbCrLf
Response.ContentType = "text/plain"
Response.Write Head
Response.Write RS.GetString(,,", ",vbCrLf,"")

See also Recordset convertor to download recordset data as DBF or MDB file.

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

Motobit.com