Connecting Oracle DB using Oracle.DataAccess.dll

[kiran198028]

Hi All,
Good Day!

I want to know how to connect to Oracle DB without oracle installed on the system.
When check in google it was told to use Oracle.DataAccess.dll. But could not do that can any one suggest how to use this dll and connect to oracle db.
Using VBA macro.

TIA

 

[sandy666]

maybe use Power BI Desktop

 

[kiran198028]

Thanks sandy666 but we don't have Power BI desktop
any other solution

 

[sandy666]

it was just an idea

Power BI

or Power Query aka Get&Transform

I don't like vba so I can't help

have a nice day