Share via

  • Article

Choose How to Import the Data

This page of the Table Import Wizard enables you to choose how to import data from the selected data source. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.

  • Select from a list of tables and views to choose the data to import
    Select this option if you want to import data by selecting from a list.

    Note

    This option is available only when the selected data source exposes schema information that the Table Import Wizard supports.

  • Write a query to specify the data to import
    Select this option if you want to import data by using a SQL query. The SQL query can manipulate the data that is imported. For example, you could join data from different tables or select only rows that meet certain criteria.