How do I create a Data Connection in Excel

Here is a demonstration of connecting to the Oracle database from Excel. Below, you will find the steps to connect to the database.

How to establish the Oracle database connection

Step 1 – Click on the data tab

Click on the data tab

Step 2 Click on other data sources

After that, click on the data connection wizard.

Step 3 Click on the ODBC DSN and then Next

Step 4 Under Control pannel, Administrative tools go to ODBC data sources

Step 5 Under User DSN, click on the Add button

Step 6: Ensure you already installed the Oracle Client of the latest version

Select the ODBC driver for Oracle.

Step 7 Give data source name, server name, password

Now your connection is established.

Step 8 – in Step 3, you can view the new Database connection. Just click on that connection and apply it.

Step 9: Now your connection is established. Click on the Data tab and hit on the refresh all tab. You will now get the data from the data source.

Keep Reading

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.