Exporting to a Spreadsheet : Access to Excel « Access « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Access
3. Access to Excel

Exporting to a Spreadsheet

 
Sub transSpread()
     DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
           "tblSales", "C:\Sales.xls"
     MsgBox "Sales spreadsheet created"
End Sub

 

Related examples in the same category