This page of the Table Import Wizard enables you to choose an existing data source connection to use. 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. For more information about supported data sources and providers, see Data Sources Supported in PowerPivot Workbooks.
Select one of the following values to display a category of data source connections in the Select a data source connection box.
Connections in the PowerPivot workbook.
Office Data Connection (.odc) files stored on the local computer.
Office Data Connection (.odc) files stored in the PowerPivot workbook.
Select a Connection
Select the data source connection to use.
Browse for More
Select an .odc file that is stored on the local machine.