Microsoft Office Tutorials and References
In Depth Information
Import Data from a Data Source
Import Data from
a Data Source
You can quickly import data into just about
any format by importing the data from a
defined data source file.
In this section, you will learn how to import
data from a data connection file . This is a data
source that connects you to a wide variety of
data, including ODBC, SQL Server, SQL
Server OLAP Services, Oracle, and Web-based
data retrieval services. You can also read the
Tip to learn how to create a data connection
When you import the data source, you can
choose to import the data to an Excel table,
directly to a PivotTable, or to both a
PivotChart and a PivotTable. You can also
import the data to an existing worksheet or to
a new worksheet.
1 Click the Data tab.
2 Click Get External Data.
3 Click Existing
The Existing Connections
dialog box appears.
4 Click the data source you
want to import.
5 Click Open.