To export Access data to Excel, select a table, query, form, or report, then choose External Data > Export > Excel. The key decision is whether to export the source data or the content currently displayed: unformatted exports of tables and queries include all fields and records, while formatted exports follow the visible view and preserve more display behavior. Check the resulting workbook for omissions, nulls, and values that need special handling.
Export Access data to Excel
- Prepare the source. Open the Access object and address visible error indicators or error values first. Microsoft warns that export problems can result in null values in the worksheet.
- Choose an object. Select a table, query, form, or report. Access exports one database object per operation. For a multiple-record view, you can select specific records before exporting.
- Open the export command. On the ribbon, choose External Data > Export > Excel.
- Set the destination and format. Choose the output file and Excel format. If exporting a table or query, decide whether to include formatting and layout.
- Check the workbook. Confirm that the expected fields and records arrived, and look for error indicators, unexpected nulls, or shifted data.
This creates a copy of the selected data in a file Excel can open; it does not convert the Access database itself into an Excel workbook. For recurring exports, save the export details as a specification. Microsoft provides separate guidance for running, scheduling, and managing saved specifications in its Export data to Excel documentation.
As an Amazon Associate I earn from qualifying purchases.
Choose formatted or unformatted export
The setting changes what is included and how some values behave. Use the mode that matches the workbook’s purpose.
| Export choice | What is included | How values and display behave |
|---|---|---|
| Without formatting and layout | For a table or query, all fields and records are exported. Format property settings are ignored. | Lookup fields export their ID values. Hyperlink contents export as text in a displaytext#address# form. |
| With formatting and layout | Only fields and records displayed in the current view or object are exported. Filters, hidden datasheet columns, and fields not shown on a form or report affect the result. | Lookup values are exported, hyperlinks remain hyperlinks, and rich text content is exported without its formatting. |
Forms and reports cannot be exported without formatting. Microsoft’s guidance also says reports can be exported only in the older XLS format, not XLSX. If a workbook needs every source field and record, use an unformatted table or query export and check that the object is not unintentionally filtered. If readability and displayed values matter more, formatted export may be a better fit—but verify what the view hides.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
What Access exports—and what it does not
- Calculated fields: Excel receives the calculated results, not the expressions that produced them. Recreate formulas in Excel if you need editable calculations.
- Multivalued fields: Values are written as semicolon-separated lists.
- Pictures, OLE object contents, and attachments: These source-data contents are not exported. Add them to the workbook separately if they are required.
- Nested objects: Exporting a form, report, or datasheet that contains subforms, subreports, or subdatasheets exports only the main object. Export nested objects separately when needed.
- Dates before January 1, 1900: These are not exported and appear as null.
- Yes/No fields displayed as “#”: Microsoft suggests opening the form in Datasheet view before exporting.
Fix common export problems
- Fields or records are missing: Check whether you exported with formatting and layout. That mode follows the displayed content, so inspect filters, hidden datasheet columns, and fields omitted from a form or report.
- Lookup values appear as numbers: An unformatted export of a table or query exports lookup IDs. Choose formatted export when the displayed lookup values are what you need.
- Formatting or hyperlinks look different: Confirm the formatting and layout setting. For formatted exports, hyperlinks remain hyperlinks, but rich text formatting is not retained; apply any additional formatting in Excel.
- Cells contain nulls or errors: Review the Access source for error indicators and values, then inspect the exported worksheet. Dates earlier than January 1, 1900 are a known case that becomes null.
- Nested data or attachments are absent: Export nested objects separately, and add pictures, OLE contents, or attachments to Excel by another method.
- A report cannot be saved as XLSX: Reports are limited to XLS export in Microsoft’s guidance. Choose a table or query instead if XLSX is required and an equivalent data export meets your needs.
Export more than one Access object
Each operation exports one database object. To combine multiple objects, export each separately and merge or organize the resulting worksheets in Excel. Review each export independently, since different objects may use different filters, displayed columns, or formatting settings.
Quick Recap
Rank #3
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
