Verifying a Data Source Name

This section describes how to verify that an application can connect to an ODBC data source using Microsoft Excel. You can accomplish the same thing with any ODBC application.

1. Select Data > Import External Data > New Database Query...

   

   If Microsoft Query is not installed, Excel offers to install it for you.

2. Select the data source name (Stock_Schema) in this example.
3. Disable "Use the Query Wizard..." and click OK.

   

4. In the Add Tables dialog, clock Close.

   

5. Click the SQL button.

   

6. Enter a simple query such as select distinct calendar_year from date_dimension and click OK.

   

7. Click OK.

   

8. The data values 2000, 2001, 2002, 2003, 2004 indicate that you have successfully connected and executed a query through ODBC.

   

9. Click File > Return Data to Microsoft Office Excel.
10. In the Import Data dialog, click OK.

    

11. The data is now available to be used in an Excel worksheet.