Chapter 2 – Getting Your Data Into PowerPivot

One of the great things about PowerPivot is that you can mash up data from many different sources. For example, you can:

• Copy and paste Excel data to PowerPivot
• Link to data in Access, SQL Server, Oracle, Teradata
• Link to data in an Excel worksheet, once the worksheet has been converted to a Table with Ctrl+T
• Import data from a simple text file

In this episode of the MrExcel podcast, watch the process of importing 1.8 million rows from a text file into Excel 2010.

Advertisement