13.4.1.Create an Excel Workbook PivotTable from an Access Database |
|
Click the Data tab. Click the From Access button.
|
|
 |
Click the table from Access you want to use. Click OK.
|
|
 |
Set Data Link Properties. Click OK.
|
|
 |
Fill OLE DB information. Click OK.
|
|
 |
Select a table. Click OK.
|
|
 |
Click the PivotTable Report or PivotChart and PivotTable Report option.
|
|
 |
Click the Existing worksheet option,
and then specify a cell location, or click the New worksheet option.
|
|
 |
Click Properties to set refresh, formatting,
and layout options for the imported data, and then click OK.
|
|
 |
|
 |