PURPOSE 
------- 
This bulletin explains how you can connect with the Excel ODBC-driver 
to a excel-workbook 
SCOPE & APPLICATION 
------------------- 
This article is useful for all persons which must open a excel-workbook in 
a Oracle-DB 
Configure Excel and DNS for ODBC 
----------------------------- 
Assume that you have created a workbook called "odbc.xls" with two columns: 
ID, NAME in cell A1,B1. There existe three rows with contents: 
A B 
1 ID Name 
2 101 x 
3 102 xx 
4 103 xxx 
Thus, the range of data is from A1 to B4. 
Mark A1:B4 and select menu "Insert -> Name -> Define". 
In the "Define Name" window type in the edit field "Names in workbook:": test. 
(In the "Refers to:" field the sheet and the range is shown. 
Here: "=Sheet1!$A$1:$B$4". ) 
Click OK. 
Now the most important thing, creating a range, is done. 
Yet you can create a datasource with your ODBC-Adminstrator (see related documents) 
Start the Oracle ODBC Test program and connect to the recent created DNS. 
Type in "select * from test" and push the execute bottom and the result 
is shown in the result pane. 
Normally the next step is to create an heterogenous service, where you can 
query your workbook via sqlplus. This is explained in Note:109730.1.