Microsoft Office Tutorials and References
In Depth Information
Importing Data from Microsoft Access
The Select Table dialog box in Figure 18-5 contains a column called Type. There are two
types of Access objects you can work with: View and Table. View indicates that the
dataset listed is an Access query, and Table indicates that the dataset is an Access table.
In this example, Sales_By_Employee is actually an Access query. This means that you
import the results of the query. This is true interaction at work; Access does all the
back-end data management and aggregation, and Excel handles the analysis and
5. Select your target table or query and click OK.
The Import Data dialog box shown in Figure 18-6 opens. Here you define where and how
to import the table. You have the option of importing the data into a Table, a PivotTable
Report, or a PivotChart and PivotTable Report. You also have the option of creating only the
connection, making the connection available for later use.
Note that if you choose PivotChart and PivotTable Report, the data is saved to a pivot cache
without writing the actual data to the worksheet. Thus your pivot table can function as
normal without you having to import potentially hundreds of thousands of data rows twice
(once for the pivot cache and once for the spreadsheet).
6. Select Table as the output view and define cell A1 as the output location (see Figure 18-6).
7. Click OK.
Figure 18-6: Choosing how and where to view your Access data.
Your reward for all the work will be a table similar to the one shown in Figure 18-7, which contains
the imported data from your Access database.