Microsoft Office Tutorials and References
In Depth Information
Import Data from a Data Source
Chapter 7: Importing Data into Excel
The Import Data dialog
box appears.
6 Click to select the Table
option.
8
6
If you want to import the
data directly into a
PivotTable, you can select
the PivotTable Report
option, instead.
7 Select the Existing
Worksheet option.
8 Click the cell where you
want the imported data
to appear.
7
9
If you want the data to
appear in a new sheet,
you can select the New
Worksheet option,
instead.
9 Click OK.
Excel imports the data
into the worksheet.
Try This!
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.
 
Search JabSto ::




Custom Search