Export to Excel 2010 from Access 2010 retuns invalid file format
Posted on 2013-12-18
I have table that I want to export, simple, but when I use the below incode, it creates the workbook, but when I try to open the file, I get a the error message that the file format or file extension is not valid.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, _
"tblExcelExportData", "C:\TEMP" & "\TestDataExport.xlsx", True
Not sure what to do as it looks fine to me