Exporting to an Excel Spreadsheet
You might want to export table data or query results to an Excel spreadsheet so that you can use Excel's analytical features. You can accomplish this in many ways. You can export an object by right-clicking it, you can export an object using drag and drop, or you can export it using the External Data tab of the Ribbon.
Exporting to an Excel Spreadsheet Using the Context-Sensitive Menu
To export table data or query results to an Excel spreadsheet, follow these steps:
- Right-click the object you want to export and select Export from the context menu. The menu expands to show all of the valid Export formats.
- Select Excel from the menu. The Export - Excel Spreadsheet dialog appears.
- Designate the file name and file format.
- Specify the desired export options (for example, if you want to export the data with formatting and layout and whether you want Excel to launch when the process is complete).
- Click OK to complete the process.
Exporting to an Excel Spreadsheet Using Drag and Drop
You can export a table or query to Microsoft Excel by dragging and dropping it directly onto an Excel spreadsheet. This whiz-bang technology makes the integration between these two powerful products virtually seamless. Here are the steps involved:
- Arrange the Access and Excel application windows so that both are visible.
- Drag the object (that is, the table or query) from the Access Navigation Pane onto the Excel spreadsheet. The results of dragging and dropping the Customers table from the Access Navigation Pane to Microsoft Excel appear.
Exporting to an Excel Spreadsheet by Using the External Data Tab of the Ribbon
You can use the External Data tab of the Ribbon to export an Access table or query to Microsoft Excel, as follows:
- Select the object you want to export.
- Select Excel from the Export group on the External Data tab of the Ribbon. The Export - Excel Spreadsheet dialog appears.
- Select the destination location and file format, as well as the export options, and click OK. The export process completes.
In this tutorial:
- Sharing Data with Other Applications
- What Is External Data?
- Looking at Supported File Formats
- Exporting to an Excel Spreadsheet
- Exporting to ASCII
- Importing from Another Access Database
- Importing ASCII Data
- Linking to Tables in Another Access Database
- Linking to Another Type of Database
- Linking to SQL Server Databases
- The Linked Table Manager