Exporting from Access for Microsoft 365 I Cannot Export to Excel Formats Later Than Excel 2003 (XLS)

Question

I've been trying to export an Access Report created in Access for Microsoft 365 to Excel but if I try to export to either XLSX or XLSM formats it creates corrupt files. I've tried using ExportWithFormatting macros, DoCmd.OutputTo & DoCmd.TransferSpreadsheet VBA Code but all 3 alternatives fail. They all work if I use XLS (Excel 2003 or earlier) format. In addition ExportWithFormatting doesn't give me an option for XLSX or XSLM formats. What am I doing wrong?

Yours sincerely

Craig Hoy

Answer 1

I was able to resolve the issue by using ImportExportToSpreadsheet and exporting to the ExcelBinary format.

yours sincerely

Craig Hoy