Home

Connect to an Oracle database.

%3CLINGO-SUB%20id%3D%22lingo-sub-854825%22%20slang%3D%22en-US%22%3EConnect%20to%20an%20Oracle%20database.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854825%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone.%20I%20am%20new%20to%20Excel%20development%20and%20need%20to%20connect%20to%20an%20Oracle%20database.%20I%20am%20using%20Excel%202019%20(64%20bit)%20on%20Windows%2010%20(64%20bit).%20I%20downloaded%20the%20Oracle%20client%20and%20installed%20it.%20I%20set%20up%20the%20TNS%20file%20to%20connect%20to%20the%20database%2C%20but%20even%20after%20all%20the%20configurations%20Excel%20warns%20that%20the%20Oracle%20components%20are%20missing%20for%20the%20connection.%3CBR%20%2F%3EWhat%20should%20I%20do%20for%20Excel%20to%20%22find%22%20the%20Oracle%20components%20to%20connect%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20Base%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOracle%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995322%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20to%20an%20Oracle%20database.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995322%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408630%22%20target%3D%22_blank%22%3E%40tiagoce%3C%2FA%3E%26nbsp%3B%20I%20also%20have%20the%20same%20problem.%20When%20going%20to%20get%20data%20tab%20there%20is%20no%20option%20to%20get%20data%20from%20Oracle%20Database.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995933%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20to%20an%20Oracle%20database.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F452059%22%20target%3D%22_blank%22%3E%40Maria1105%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%3C%2FA%3E%20if%20Orcale%20connector%20is%20available%20for%20your%20version%20of%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
tiagoce
Occasional Visitor

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?

2 Replies

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

@Maria1105 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies