How To Export Data from Microsoft Access 2007 to Microsoft Excel

  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.