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

Craig Hoy 96 Reputation points

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 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
598 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful