Access enables you to store and summarize data stored in your database tables, but Excel provides a much wider range of analytical tools. Exporting your Access table or query data to an Excel workbook takes just a few steps, after which you can analyze your data using all of the capabilities Excel has to offer.

Exporting Data to Excel

1. Click the table or query you want to export.

2. Click the External Data tab.

3. In the Export group, click the Export to Excel Spreadsheet button.

4. Type a name for the file.

5. If desired, select the Export Data With Formatting And Layout option.

6. Click OK.

7. Click Close.

   

Tip

If you select the Save Export Steps check box, Access will display a form you can use to record the export so you can recall it later. To recall the export, on the External Data tab, in the Export group, click Saved Exports, click the export you want to replay, and then click Run.