Mega Code Archive

 

Categories / VisualBasic Script / Access

 

Export table as xls file

Public Sub ExportTable()    DoCmd.OutputTo acOutputTable, "tblCustomer", acFormatXLS, _                   "C:\BegVBA\Customer.xls" End Sub