Export Question

• TheRedneckDBA

  SSChampion

  Points: 14001

  More actions

  October 27, 2005 at 10:18 am

  #76447

  Cann anyone tell me the difference between these two lines of code?

  DoCmd.OutputTo acOutputTable, "dbo.tblTempExport", acFormatXLS, filename, False

   

  DoCmd.TransferSpreadsheet acExport, SpreadsheetTypeExcel9,  "dbo.tblTempExport", filename

  I couldn't get TransferSpreadsheet to work correctly, and switched to OutputTo after seing someone using it on google, but would like to know what the difference is between them.

  Thanks!

  Jason

   

   

  The Redneck DBA

• Bill Scott

  SSCrazy

  Points: 2328

  More actions

  October 28, 2005 at 9:24 am

  #600951

  transferspreadsheet wants the target xls file to already exist.  haven't used the output to.