Table Import Wizard Reference

This section provides Help on the Table Import Wizard. This wizard enables you to import data from a variety of data sources. To access this wizard in the PowerPivot window, on the Home tab, in the Get External Data group, click the button that corresponds to the type of data that you want to import (such as data from a database).

For information about supported data sources, see Data Sources Supported in PowerPivot Workbooks. For an overview of the user interface, see Take a Tour of the PowerPivot UI.

In This Section

Term	Definition
Advanced Settings	Specify the encoding and the locale for the flat file that you are connecting to.
Analysis Services MDX Query Designer (PowerPivot)	Create a query that specifies the data to import from a Microsoft SQL Server Analysis Services data source.
Choose How to Import the Data	Specify how to import data from the selected data source.
Connect to a Data Source	Create a new data source connection, to a variety of data sources such as relational databases, data feeds, and files.
Connect to a DataMarket Dataset	You can import data from Windows Azure Marketplace DataMarket to PowerPivot as a table. DataMarket is a service that enables you to discover free and commercial data from a variety of content providers.
Connect to a DB2 Database	Connect to a DB2 database.
Connect to a Flat File	Connect to a flat file (.txt), tab separated file (.tab), or a comma separated file (.csv).
Connect to a Microsoft Access Database	Connect to a Microsoft Access database.
Connect to a Microsoft Excel File	Connect to a Microsoft Excel file.
Connect to a Microsoft SQL Azure Database	Connect to a Microsoft SQL Azure database.
Connect to a Microsoft SQL Server Database	Connect to a Microsoft SQL Server database.
Connect to a Microsoft SQL Server Parallel Data Warehouse	Connect to a Microsoft SQL Server Parallel Data Warehouse.
Connect to a Report or Data Feed	Connect to a data feed from an Atom service document or to data feeds from a SQL Server Reporting Services report.
Connect to a Sybase Database	Connect to a Sybase database.
Connect to a Teradata Database	Connect to a Teradata database.
Connect to an Informix Database	Connect to an Informix database.
Connect to an Oracle Database	Connect to an Oracle database.
Connect to Microsoft SQL Server Analysis Services	Specify settings to import data from a Microsoft SQL Server Analysis Services cube or a PowerPivot workbook that is hosted on SharePoint.
Data Source Credentials	Specify the user name and password for the existing data source connection that you selected.
Details [Table Import Wizard]	View information about a data import operation that failed.
Filter Details	View the filter for the data import.
Import Summary	View the options you have selected for the data import.
Importing [Table Import Wizard]	View the progress of the data import operation.
Preview Selected Table	Preview the data in the selected table, select the columns to include in the data import, and filter data in the selected columns.
Relational Query Designer (PowerPivot)	Create a query that specifies the data to import from a relational database.
Select an Existing Connection	Choose an existing data source connection to use.
Select Tables and Views	Select the tables and views that you want to import data from.
Select Tables and Views (Data Feeds)	Select the tables and views that you want to import data from for a data feed.
Set Advanced Properties	Specify additional property settings for a data source connection.
Specify a Connection String	Connect to an OLE DB or ODBC data source.
Specify a SQL or MDX Query	Import data by using a SQL query.

See Also

Concepts

Take a Tour of the PowerPivot UI

Other Resources

Add and Maintain Data in PowerPivot

UI Reference (PowerPivot for Excel)