Download recordset as a CSV (DBF, MDB) file
ActiveX RegEdit. ActiveX User account Manager Pure-ASP Upload
Export MDB/DBF from ASP Active LogFile WebChecker ActiveX/ASP Multi Dictionary object

See also	IISTracer, real-time IIS monitor and logging tool. Huge ASP file upload with progress bar.

Do you like this article?
Please, rate it
and write review!
Rated:

by Aspin.com users

What do you think?

Top messages

22.3.2003 19:18:41

Read and write SQL image data, store binary file to sql table.

(nbsp;WSH, Database, Conversion, VBScript)

4.5.2002 9:16:43

Send an email from ASP (WSH) using VBSscript, CDONTS and Outlook.

(nbsp;ASP / ASP.Net, WSH, VBScript, Email)

3.1.2001 13:00:48

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

(nbsp;Conversion, VBScript)

Download recordset as a CSV (DBF, MDB) file

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.

See also for 'Download recordset as a CSV (DBF, MDB) file' article:

ASP/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.

If you like this page, please include next link on your pages:

<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>

IISTracer - IIS ISAPI real-time monitor IISTracer is a real-time monitoring tool for Microsoft IIS, which will show/log you what is happenning on IIS server right now. It let's you reveal problems with long-running scripts (.asp, .cgi, cfm...), hang-up states and low resource situations and lets you stop long-running requests (uploads/downloads).	ActiveX User account Manager - Set of simple objects for creating, deleting, and managing user accounts, groups, servers and domains in the Windows NT environment.
Active log file - Hi-performance text file logging for ASP/VBS/VBA applications. Lets you create daily/weekly/monthly log files with variable number of logged values and extra timing and performance info.	ActiveX windows registry editor - Intuitive, easy to use COM interface to windows registry. Set of classes to read/enumerate/modify windows registry keys and values from ASP, VBS and T-SQL.
ActiveX/ASP Multi Dictionary object - Free-threaded hi-speed dictionary algorithm with unique/nonunique keys (map/multimap). Connect to another dictionary object in the same process. Lock and Unlock methods to synchronize tasks (application scope). Share ASP Application/Session objects.	Export DBF/MDB from ASP - Conversion from recordset to MDB/DBF. Direct binary output of MDB or DBF files from ASP pages with one row of code.
Pure-ASP upload - lets you upload files using Pure ASP VBS code (using multipart/form-data and input type=file).	ByteArray - Works with safearray binary data (VT_UI1 \| VT_ARRAY) - save/restore binary data from disk, find, work with code pages, convert to string/hexstring(SQL).
WebChecker - Checks http, https, ftp and gopher internet connections in regular intervals. Lets you monitor web site functionality (uptime). Enables restart or notification on problems.	HTTPLog ISAPI filter - Lets you log incomming/outgoing http header and document data to separate files. Monitor of IIS service input/output.