Connect to an Oracle database.

Question

Hello everyone. I am new to Excel development and need to connect to an Oracle database. I am using Excel 2019 (64 bit) on Windows 10 (64 bit). I downloaded the Oracle client and installed it. I set up the TNS file to connect to the database, but even after all the configurations Excel warns that the Oracle components are missing for the connection.
What should I do for Excel to "find" the Oracle components to connect?

maria1105 · Answer

tiagoce&nbsp; I also have the same problem. When going to get data tab there is no option to get data from Oracle Database.&nbsp;

sergeibaklan · Answer

Maria1105&nbsp;
Please check here&nbsp;https://support.office.com/en-us/article/where-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16 if Orcale connector is available for your version of Excel.

elarr250 · Answer

SergeiBaklan&nbsp;Oracle database is available for my version of Excel (at least should be) but still I don't have that option in Excel.&nbsp;

sergeibaklan · Answer

Elarr250&nbsp;
Strange. Are you on 2019/2021 Pro or on 365 Enterprise and is that Windows?

elarr250 · Answer

SergeiBaklan&nbsp;Yes, it is strange.I use Microsoft 365 Apps for business and operation system is Windows10.Is it possible that some kind a update change something?&nbsp;I can also share picture:

Forum Discussion

Connect to an Oracle database.

10 Replies

Resources