This section demonstrates how ODBC works through the PC product
Microsoft Excel. This procedure may vary depending on your version
of Excel. These instructions specifically explain Microsoft Excel
Open a blank worksheet in Excel.
Select Data, then select the Get External Data option.
Select Create New Query.
Figure 1.1. Create new query in
Double-click New Data Source.
Figure 1.2. Create new query in
Make sure that you have not checked the Use Query Wizard
Enter a name for the Data Source.
Set the driver type to the OpenLink Lite Driver for the database
you wish to access.
Figure 1.3. Creating a new query
using MS Query
The system takes you to the Setup Dialog for the OpenLink Lite
driver you are using. The example shown is the setup dialogue for
OpenLink Lite for Oracle. For details on filling in the setup
dialogue for the driver you are using refer to the User Guide
installed with the driver.
Figure 1.4. Create new query in
When you are satisfied you have correctly filled in the setup
dialog click OK. The OpenLink login dialog is then displayed.
Figure 1.5. Create new query in
Enter a valid username and password.
Click OK. The system takes you back to the Creating a Data
Click OK. This saves the data source you just created.
Figure 1.6. Create new query in
Double-click the data source you just created. This will take
you to the database tables.
Figure 1.7. Create new query in
Scroll down the table list and highlight the table containing
the data you require. Click Add.
Click Close to close the Add Tables dialog box. The MS Query
Scroll to the field you want. Highlight this field and
Click File on the MS Query menu bar. Select the Return Data to
Microsoft Excel option.
Confirm the destination area. Click OK.
Figure 1.8. Click on file in the
MS Query menu bar
The system takes you back to the OpenLink ODBC Login screen.
Supply your username and password. Click OK.