Share via


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

Other Resources

UI Reference (PowerPivot for Excel)