1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

How To Export Data from Microsoft Access 2010 to Microsoft Excel

By

How To Export Data from Microsoft Access 2010 to Microsoft Excel
Mike Chapple
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 2010. Instructions are also available for those using Access 2007 or 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 2010
  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.

What You Need

  • Microsoft Office 2010
  1. About.com
  2. Technology
  3. Databases
  4. Microsoft Access
  5. Tutorials
  6. Exporting Data: Microsoft Access 2010 to Microsoft Excel

©2014 About.com. All rights reserved.