How Excel worksheets Import Access database data

how Excel worksheets Import Access database data

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 "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 "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 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.