Microsoft Excel

Before connection to JDBC can be made you must ensure the JDBC to ODBC Bridge has been set up.

Open the Data tab and select Get Data

Open

Then from Data > From Other Sources > From ODBC

Open

Select the ODBC data source you created

A. Click OK and view all the available tables we expose to the navigator.

OR

B. Expand the Advanced table and provide a custom query

On the Windows tab select the Use my current credentials

Click Connect

Select the table or tables you which to import

Click Load