MOTOBIT.COM - ASP upload, IIS utility Recordset converter

Library Recordset converter | Changes | Purchase | Download

Description of Recordset converter

Recordset converter is a library for converting DAO or ADO recordsets to MDB or DBF files. It enables direct binary output of MDB or DBF files from ASP pages with one row of code. The object also supports on-the-fly compression by zip/arj.

Links

Download 60 day evaluation version
Download this help

License

Shareware About prices and registration

Features of Recordset converter

Direct output of binary DBF files from ASP/ASP.Net using Response.BinaryWrite
Simple, one-row source code to export recordset from ASP.
Works with any type of source data columns (integer/numeric, autonumber, character, unicode character, money, float, …)
Designed to work with ASP (VBScript/Jscript), and any version of VBA (VBA5, VBA6, Word, Excel, MSAccess, …). Works also with ASP.Net (ASPX, VB.Net, C#)
Any data source for DBF/MDB export - MS SQL database, oracle, MDB files, DBF files, text (csv), ...
Accepts ADODB.Recordset or DAO.Recordset as a data source.
Let's you Compress outgoing files using zip/arj command line (simply add one row of source code)
Let's you Compress outgoing files using zip/arj command line (simply add one row of source code)
VBA6 source code is available with Distribution license, please see License page for Recordset converter

Performance tests

Brief overview of Recordset convertor performance.

Recordset converter classes

DBF		Object for converting DAO or ADO recordset to the DBF file. It enables direct output of DBF files from the ASP page.
MDB		Object for converting DAO or ADO recordset to the MDB file. Faster than DBF, MDB enables distribute large binary and text fields.

Recordset converter enums

DatabaseTypeEnum

MDB Database types.

Examples

Simple DBF from ADO sample

<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
  'Sets the content type
  Response.ContentType = "application/vnd.ms-excel"
  'Specify filename for download
  Response.AddHeader "Content-Disposition", "attachment;filename=Orders.DBF"
  
  'Create RecordSet and DBF objects
  Set ADORS = CreateObject("ADODB.Recordset")
  Set DBF = CreateObject("RSConvert.DBF")
  
  'Open table
  ADORS.Open "Orders", "DSN=ADOSamples"

  'Write DBF file to the client
  Response.BinaryWrite DBF.GetFile(ADORS)
  
  'Close recordset
  ADORS.Close
</SCRIPT>

Send two recordsets in MDB

<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
  'Sets the content type
  Response.ContentType = "application/vnd.ms-access"
  'Specify filename for download
  Response.AddHeader "Content-Disposition", "attachment;filename=Results.MDB"
  
  'Create RecordSet and MDB objects
  Set ADORS = CreateObject("ADODB.Recordset")
  Set MDB = CreateObject("RSConvert.MDB")
  
  'Open table Orders
  ADORS.Open "Orders", "DSN=ADOSamples"
  'Add table "Orders" to database
  MDB.AddRS ADORS
  ADORS.Close

  'Open table Payments
  ADORS.Open "Payments", "DSN=ADOSamples"
  'Add table "Payments" to database
  MDB.AddRS ADORS
  ADORS.Close

  'Write MDB file to the client
  Response.BinaryWrite MDB.GetBinary
  
</SCRIPT>

XML/PAD | All samples | Other libraries