question

CraigHoy-7951 avatar image
0 Votes"
CraigHoy-7951 asked CraigHoy-7951 answered

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

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

microsoft-365-apps-publishing-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CraigHoy-7951 avatar image
0 Votes"
CraigHoy-7951 answered

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

yours sincerely

Craig Hoy

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.