How to configure Microsoft Excel to connect to an Oracle Database

Mike van der Velden, Product Manager at Simba Technologies, provides a step-by-step guide for configuring Microsoft Excel to connect with Oracle Database OLAP Option. Mike walks through the one-time set-up of Oracle's Transparent Networking Substrate (TNS), followed by the Data Source Name (DSN) and Office Data Connection (.odc). Once configured, Microsoft Excel connects easily to Oracle Database OLAP Option for ad hoc data query, data analysis and BI reporting.

[mariogreco]

Thanks for this video. I've been looking to connect via odbc to an orcl db for 3 months, and finally did it with this. What helped me was installing instant client for the odbc drivers and the first windows advanced settings, setting up the variables and tns_admin.

[ArmandoReportes]

This allowed me to connect after much browsing dead ends. Thanks.

[qydeng]

good demo, clear and loud. thank for sharing.

[dtovee]

Thanks, the 32/64bit config was very useful.

[dougkampe]

Appreciate the help. The next step is to bridge my oracle and sql databases.

[AlexKilkka]

Great video! Thank you so much for posting, it took forever to figure this out and your video nailed it.

[sherek]

The missing part for me, was the declaration of the environment variable TNS_ADMIN. Thank you so much!Great content!

[aevp]

Excelente Tutorial, bien explicado y sencillo. Muchos éxitos...

[melikeertunc]

hi Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?

[vijayarajbijapure]

Hi Mike,
I dont have any DB installed on my computer. I usually connect to Oracle DB using SQL developer which takes hostname, portnumber and SID to get connected. In such case, how do we perform setups ?

[GameHutZzz]

I can't find oracle driver when set up a data source? But I can connect with Toad for oracle. Why the oracle driver can't found?

[SteveBegin]

Do you know what I would do differently for a network-based file DSN?

[SelvinCristo]

Hi sir how to connect with existing ODBC driver (microsoft paradox driver) into excel.
Please advise

[uncommonsense]

Do you know of any videos that show how to do this with SAP?

[shabihulhasnain]

This is onPrim, I am looking for the Cloud one.

[cindly_cute]

Purchase I game office jayendraganj company lg