Export an Access Database Table into an Excel Workbook : Access Database « Collaboration « Microsoft Office Excel 2007 Tutorial






Start Microsoft Office Access 2007. 
           Open a database, and then display Tables in the task pane.
Start Microsoft Office Access 2007. Open a database, and then display Tables in the task pane.
Click a table. 
           Click the External Data tab. 
           Click the Excel button in the Export group.
Click a table. Click the External Data tab. Click the Excel button in the Export group.
Specify the destination file name and format.
Specify the destination file name and format.
Specify the export options.
           Click OK, and then click Close.
Specify the export options.








13.4.Access Database
13.4.1.Create an Excel Workbook PivotTable from an Access DatabaseCreate an Excel Workbook PivotTable from an Access Database
13.4.2.Export an Access Database Table into an Excel WorkbookExport an Access Database Table into an Excel Workbook