Database Reference
In-Depth Information
Unlike SQL Server databases, Microsoft Access databases are typically found on local desktops and
directories. This means you can typically import data from Access without the help of your IT depart-
ment. Follow these steps to do so:
1. Open the Power Pivot window and click the From Other Sources button on the Home tab.
2. In the Table Import Wizard, shown in Figure 4-9, select the Microsoft Access option and click
the Next button.
Figure 4-9: Select Microsoft Access to import data from Access.
3. Fill in the information the wizard needs to connect to your database (see Figure 4-10).
In this screen, you need to provide
Friendly Connection Name: This field allows you to specify your own name for the external
source. Enter a name that is descriptive and easy to read.
Database Name: Enter the full path of your target Access database. You can click the
Browse button to search for and select the database you want to pull from.
Search WWH ::




Custom Search