Access VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Access
  4. Export table as xls file
Public Sub ExportTable()
   DoCmd.OutputTo acOutputTable, "tblCustomer", acFormatXLS, _
                  "C:\BegVBA\Customer.xls"
End Sub