Save table from ADOSamples

Examples

Save table from ADOSamples
'Create Recordset and DBF objects Set ADORS = CreateObject("ADODB.Recordset") Set DBF = CreateObject("RSConvert.DBF") 'Open table ADORS.Open "Customers", "DSN=ADOSamples" 'Save table to the disk DBF.SaveRS "c:\dbfexport\Custo", ADORS 'Close recordset ADORS.Close ADORS.Open "Products", "DSN=ADOSamples" DBF.SaveRS "c:\dbfexport\Products", ADORS ADORS.Close

  'Create Recordset and DBF objects
  Set ADORS = CreateObject("ADODB.Recordset")
  Set DBF = CreateObject("RSConvert.DBF")
  
  'Open table
  ADORS.Open "Customers", "DSN=ADOSamples"
  'Save table to the disk
  DBF.SaveRS "c:\dbfexport\Custo", ADORS
  'Close recordset
  ADORS.Close
  
  ADORS.Open "Products", "DSN=ADOSamples"
  DBF.SaveRS "c:\dbfexport\Products", ADORS
  ADORS.Close

Other links for Save table from ADOSamples

RSConvert.DBF

Object for converting DAO or ADO recordset to the DBF file. It enables direct output of DBF files from the ASP page.

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.