How to Export Data from Microsoft Access 2007 to MS Excel

It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

Let’s take a few moments to walk through the process, step-by-step.

Note: These instructions apply to Microsoft Access 2007.

Instructions are also available for those using earlier versions of Access.

Difficulty: Easy

Time Required: 10 minutes

Here's How:

1. Open the database you wish to export data from in Microsoft Access 2007
2. Using the navigation pane, select the table, report, form or query that you wish to export.
3. Choose the External Data tab on the Ribbon.
4. Click the Excel button in the Export section of the External Data tab.
5. Provide an export file name and select the Excel format you would like to use for your export.
6. Click OK to begin the export.