Trying to Access Oracle table but getting a message that Oracle.DataAccess.Client is not installed

Question

Greetings,&nbsp;I'm using windows 10 (64bit) and MS Excel 2019. Trying to Get data from table in Oracle database. When I do that selecting source as Oracle, I got message stating that The recommnded provider ('Oracle.DataAccess.Client') is not installed,...I serached the net, and installed Oracle client for Microsoft tool (64 bit version), however the message still get displayed.&nbsp;Any enountered this and resolved it?&nbsp; Appreciate any help to resolve this issue.&nbsp;&nbsp;&nbsp;

harun24hr · Answer

Thamer_Tarabzouni&nbsp;I use oracle instant client for Windows.https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.htmlThen configure ODBC connection to oracle server.https://learn.microsoft.com/en-us/sql/odbc/microsoft/configuring-the-odbc-driver-for-oracle?view=sql-server-ver16&nbsp;Then use data import wizard using that ODBC connection.

Forum Discussion

Trying to Access Oracle table but getting a message that Oracle.DataAccess.Client is not installed

1 Reply

Resources