Share via


Import Data from a Database

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. For more information about supported data sources and providers, see Data Sources Supported in PowerPivot Workbooks.

Note

In Windows Vista and Windows 7, features in the PowerPivot window are available on a ribbon, which is discussed in this topic. In Windows XP, features are available from a set of menus. If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see The PowerPivot UI in Windows XP.

The following table describes, for each type of database, how to access the Table Import Wizard from the Get External Data group. Complete the steps in the wizard to connect to a database and import data. On the Choose How to Import the Data page you can specify whether to select from a list of tables and views or write a query that specifies which data to import.

Data source

Table Import Wizard access

Microsoft SQL Server database

Click From Database, and then click From SQL Server.

Microsoft Access database

Click From Database, and then click From Access.

Microsoft SQL Server Analysis Services cube

Click From Database, and then click From Analysis Services or PowerPivot. For more information, see Import Data from Analysis Services or PowerPivot.

Microsoft PowerPivot cube (hosted on SharePoint)

Click From Database, and then click From Analysis Services or PowerPivot. For more information, see Import Data from Analysis Services or PowerPivot.

Microsoft SQL Azure

Microsoft SQL Server Parallel Data Warehouse

Oracle

Teradata

Sybase

Informix

IBM DB2

OLE DB/ODBC

  1. Click From Other Sources.

  2. In the Table Import Wizard, on the Connect to a Data Source page, select the type of database that you want to connect to, and then click Next.

See Also

Other Resources

Adding Data to PowerPivot

Data Sources Supported in PowerPivot Workbooks

Refreshing or Changing Imported Data