Access VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Access
  4. Exporting to a Spreadsheet
Sub transSpread()
     DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
           "tblSales", "C:\Sales.xls"
     MsgBox "Sales spreadsheet created"
End Sub