Excel

Setting up ODBC for Excel

Complete the following steps in order to set up the ODBC data source needed to connect to the warehouse using Excel:

1) Go to your control panel

2) Select Administrative Tools

3) Select Data Sources (ODBC)

4) Select the "System DSN" tab

5) Click on the "ADD" button

6) Select the "Microsoft ODBC for Oracle" driver

7) In the pop up box enter BANREP in every box except the user name box (put your warehouse userid or leave blank)

8) The next time you start Excel, you should see the BANREP connection as one of the options.

Connecting to the data warehouse using Excel

Below is a documentation on how to connect to the data warehouse using Excel:

Connecting to the data warehouse using Excel
[Connecting_to_the_datawarehouse_using_Excel.pdf - PDF - 218.45 KB]

Performing a query using Excel

Below is a documentation on how to perform a query using Excel:

Performing a query using Excel
[Performing_query_using_excel.pdf - PDF - 515.7 KB]

Back to top