How to Create Data Connection in Excel

Adding a data connection to Excel is often needed to get data from Table; explained easy ways to do it.

How to establish the Oracle database connection

Step 1 – 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 panel, 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