Simple code to create DBF and write from ASP | |
---|---|
<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> |
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.
© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz