Data Import & Export

Export a Microsoft Access Report to XLSX Instead of XLS

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

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

Export a Microsoft Access Report to XLSX Instead of XLS
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.
Before you start

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.

Solution 1Recommended

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.

1
Identify the data source

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.

2
Open the VBA editor

Press Alt+F11, then choose Insert > Module in the VBA editor.

3
Add the export procedure

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

4
Run and check the export

Place the cursor inside the procedure and press F5. Open the resulting Report.xlsx file in Excel and verify the rows, columns, and values.

Export the Report’s Underlying Query to XLSX Using VBA
Report layout is not exported: If you need the visual report layout, consider exporting the report to PDF instead. Creating a formatted XLSX version may require additional Excel automation or manual formatting.
Free Microsoft Office alternative

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. 1. Open the XLS export: In WPS Office, select Open and choose the XLS file exported from Access.
  2. 2. Save an XLSX copy: Select Menu > Save As and choose the XLSX workbook format.
  3. 3. Check the result: Open the saved XLSX file in WPS Spreadsheets and review its data and formatting.
Open an existing XLS report export and save a copy as XLSXCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for a smoother transitionFree and lightweight tools for everyday office work
microsoft office alternative - wps office

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.