Posted on 2004-04-12
Below is the code ued to export from Access table to Excel. Error occures. "Failure creating file".
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Exll", "D:\BalancePay\test.xls"
I would like to know, how to export tables in different sheets in same workbook.