How to Export Data from MS Access to Excel

Quick summary

Exporting data from Microsoft Access to Excel lets you analyze and share database records using Excel's familiar spreadsheet tools. This process uses the built-in External Data tab and Export - Excel Spreadsheet dialog to transfer tables, queries, or forms in just a few clicks.

Steps

1. Open your Access database and ensure the table, query, or form you want to export is available.
2. In the Navigation Pane, click on the table or query you want to export.
3. Click on the External Data tab on the Ribbon.
4. In the Export group, click Excel.
5. In the Export - Excel Spreadsheet dialog box, specify the location and file name for the Excel file.
6. Check Export data with formatting and layout if required, and choose whether to open the destination file after the export operation is complete.
7. Click OK to start the export process.
8. If you selected Save Export Steps, name and save the settings for future use.
9. Click Save Export to store your export configuration.
10. Open the exported Excel file to ensure the data was transferred correctly.