Export Table to Excel for MS Access Professional

Microsoft Access is an efficient program for creating and maintaining databases. You can use Excel spreadsheets to manipulate and assess the data that is kept in an Access table. Microsoft has made it simple for the Office applications to collaborate with each other to do various things. Exporting your data from Microsoft Access to be analyzed in Excel takes only a few minutes.

Step 1

Open the database that contains the data you want to export in Access. Click on “File,” then “Open” if you are using Access 2003 or earlier. Click on the “Office” button and then “Open” in Access 2007.

Step 2

Choose what you want to export. You can open the table to export certain rows of data or export the entire table. To export just some of the data in the table, double-click the table to open it and then highlight the rows you want. To export the entire table, click it once in the Objects window.

Step 3

Export the data to Excel. Click on “File,” then “Export” if you are using Microsoft Access 2003 or earlier. The “Export” dialog box appears. Click the drop-down box next to “Save as type.” Choose one of the Excel formats (depending on your version of Excel). Click the check box next to “Save formatted.” Click “Save Selection” if you selected certain rows within the table. Click “Export All” if you want to export the entire table. For Access 2007, click on the “External Data” tab in the ribbon. Click “Excel” under the “Export” section. Follow the wizard to export the data you want to an Excel file.

Overview of Exporting Data from Access

You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which these types of objects can be exported.

To export data from Access, first select the table or other database object to export in the Navigation Pane. Next, click the “External Data” tab in the Ribbon. In the “Export” button group, then click the button for the file format to which to export the selected object.