PowerPivot: Import Data from a SQL Server Database (Video)
This video is third in a series about using PowerPivot to import data into an Excel workbook. In this video, Michele shows you how to import data from a SQL Server relational database.
Tutorial video by Michele Hart, Microsoft SQL Server Technical Writer.
View all the PowerPivot videos on YouTube in the official SQL Server PowerPivot playlist.
In PowerPivot for Excel, you can import data from a variety of relational databases and multidimensional sources by using the Table Import Wizard. The wizard is available in the PowerPivot window, on the Home tab, in the Get External Data group. To connect to a data source, you must have the appropriate provider installed on your computer.
See Also
External Links
- PowerPivot page on TechNet
- Import Data into PowerPivot from a Database on the TechNet Library
- PowerPivot Help on the TechNet Library
- PowerPivot Web site - Download page
- PowerPivot Web site - Videos page
Autres Langues