Microsoft Office Tutorials and References
In Depth Information
Import Data from a Data Source
Chapter 7: Importing Data into Excel
The Import Data dialog
6 Click to select the Table
If you want to import the
data directly into a
PivotTable, you can select
the PivotTable Report
7 Select the Existing
8 Click the cell where you
want the imported data
If you want the data to
appear in a new sheet,
you can select the New
9 Click OK.
Excel imports the data
into the worksheet.
To create your own data connection (.odc) file, click the Data tab, click Get External
Data, click From Other Sources, and then click From Data Connection Wizard. Click the
data source you want and then click Next.
The next steps depend on the data source. For example, for Microsoft SQL Server or
Oracle, you specify the server name or address and your server login data; similarly, for
ODBC DSN (Database Source Name), you choose the ODBC data source, specify the
location of the file, and select the table or query you want to connect to.
When you get to the Import Data dialog box, click OK to import the data or click Cancel
if you just want to create the data source file for now.