How do worksheets import Access database data in Excel2013
1, Start Excel 2013, open the worksheet that you want to import Access database data on, and on the Data tab, in the Get External Data group, click the From Access button, as shown in Figure 1. Open the Select Data Source dialog box, select the database file as the data source, and then click the Open button, as shown in Figure 2.
Figure 1 Click the From Access button.
Figure 2 The Select Data Source dialog box.
2. Open the Select Table dialog box and select the table you want to import into the worksheet, as shown in Figure 3. When you finish setting up, click OK to close the Select Table dialog box.
Figure 3 The Select Table dialog box.
3, open the Import Data dialog box, select how the data is displayed in the workbook, here Select the PivotTable radio button, where the data is placed in the default setting as shown in Figure 4, click the Properties button, open the Connection Properties dialog box, and enter the connection name in the Connection Name text box. Other settings items use the default values, and then click OK to close the dialog box, as shown in Figure 5.
Figure 4 The Import Data dialog box.
Figure 5 The Connection Properties dialog box.
4. When you click the OK button to close the Import Data dialog box, you can insert the PivotTable report on the worksheet based on the data source you selected. Open the PivotTable Field pane, and then add fields to the PivotTable report by selecting the appropriate check boxes in the Select fields to add to reports column, as shown in Figure 6.
more knowledge please pay attention to Triple Excel Tutorials column