Excel® 2013 On Demand

Getting Data from Microsoft Access

Information you want to analyze may not always exist in an Excel workbook; you might have to retrieve it from another Office program, such as Access. Access table data can be easily converted into Excel worksheet data. Before you can analyze Access data in a workbook, you must convert it to an Excel file. You can either use the Excel command in Access to export data as an Excel table file, or use the PivotTable or PivotChart and PivotTable Report option in Excel to use the Access data as a PivotTable, a table you can use to perform calculations with or rearrange large amounts of data.

Export an Access Database Table into an Excel Workbook

In Access, open the database you want, and then display Tables in the ...