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 |
|---|---|
Specify the encoding and the locale for the flat file that you are connecting to. |
|
Create a query that specifies the data to import from a Microsoft SQL Server Analysis Services data source. |
|
Specify how to import data from the selected data source. |
|
Create a new data source connection, to a variety of data sources such as relational databases, data feeds, and files. |
|
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 flat file (.txt), tab separated file (.tab), or a comma separated file (.csv). |
|
Connect to a Microsoft Access database. |
|
Connect to a Microsoft Excel file. |
|
Connect to a Microsoft SQL Azure database. |
|
Connect to a Microsoft SQL Server database. |
|
Connect to a Microsoft SQL Server Parallel Data Warehouse. |
|
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 Teradata database. |
|
Connect to an Informix database. |
|
Connect to an Oracle database. |
|
Specify settings to import data from a Microsoft SQL Server Analysis Services cube or a PowerPivot workbook that is hosted on SharePoint. |
|
Specify the user name and password for the existing data source connection that you selected. |
|
View information about a data import operation that failed. |
|
View the filter for the data import. |
|
View the options you have selected for the data import. |
|
View the progress of the data import operation. |
|
Preview the data in the selected table, select the columns to include in the data import, and filter data in the selected columns. |
|
Create a query that specifies the data to import from a relational database. |
|
Choose an existing data source connection to use. |
|
Select the tables and views that you want to import data from. |
|
Select the tables and views that you want to import data from for a data feed. |
|
Specify additional property settings for a data source connection. |
|
Connect to an OLE DB or ODBC data source. |
|
Import data by using a SQL query. |
See Also
Concepts
Other Resources
UI Reference (PowerPivot for Excel)