Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-13 The Existing Connection dialog box.
Loading from Access
Now that you have seen all the ways data can be loaded from relational databases, we can
describe other data sources, the first of which is the Microsoft Access data source. Many
Microsoft Office users are used to storing information in Access databases, so PowerPivot
provides an Access data source that can load data from Access in much the same way you
do with SQL Server.
Clearly, when you open the Table Import Wizard with an Access data source, the connection
parameters are slightly different because Access databases are stored in files on disk instead
of being hosted in server databases. In Figure 5-14, you can see the Table Import Wizard
asking for an Access file.