Export a Microsoft Access Report to XLSX Instead of XLS
Question details
Export data from a Microsoft Access report to an XLSX workbook instead of the older XLS format.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user wants a modern Excel workbook from an Access report after upgrading to Microsoft 365.
- Observed behavior
- The report export tools offer XLS rather than a direct XLSX option.
Open the report in Design View and check its Record Source in the property sheet to identify the table or saved query supplying its data. If the report uses filters or calculated controls, determine whether those results are also available in the query.
Export the Report’s Underlying Query to XLSX Using VBA
Use this method when you need the report data in XLSX and do not need to preserve the report’s printed layout.
TransferSpreadsheet exports a table or saved query, not the report object itself. Report formatting, grouping, calculated controls, and report-specific filters may not appear in the workbook unless they are represented in the query.
In Access, open the report in Design View and check Property Sheet > Data > Record Source. If necessary, create and save a select query with the fields and criteria you need.
Press Alt+F11, then choose Insert > Module in the VBA editor.
Enter this procedure in the module, replacing QueryName with your saved query and the path with an existing folder: Sub ExportReportData() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "QueryName", "C:\Path\Report.xlsx", True End Sub
Place the cursor inside the procedure and press F5. Open the resulting Report.xlsx file in Excel and verify the rows, columns, and values.

Convert an Existing XLS Report Export to XLSX in Excel
Use this method if Access can export the report to XLS and you want to convert the resulting workbook.
Open and Convert Excel Exports with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Open an existing Access XLS export in WPS Spreadsheets and save it as XLSX for an easier transition between Office workflows. WPS does not directly export an Access report.
- 1. Open the XLS export: In WPS Office, select Open and choose the XLS file exported from Access.
- 2. Save an XLSX copy: Select Menu > Save As and choose the XLSX workbook format.
- 3. Check the result: Open the saved XLSX file in WPS Spreadsheets and review its data and formatting.

Frequently Asked Questions
Can TransferSpreadsheet export an Access report directly?
No. Use DoCmd.TransferSpreadsheet with a table or saved query that supplies the report’s data. It does not export the report object or its layout.
Will the XLSX export include my report’s filters and calculated fields?
Only if those filters and calculations are included in the exported query or table. Check the report’s Record Source and any report-specific filters or calculated controls before exporting.
How can I preserve the report’s visual layout?
Use Access’s External Data > Export options to export the report to PDF if a fixed visual layout is sufficient. For a formatted XLSX workbook, additional Excel automation or manual formatting may be needed.
Does saving an XLS file as XLSX recover missing rows?
No. File > Save As changes the workbook format but cannot restore rows or other data omitted during the original XLS export. Export the underlying query directly to XLSX when you need to avoid XLS format limits.




