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.