Connect to Oracle DB using vba

Dear Expert ,

is there is a way i can connect to Oracle database from VBA code without installing oracle client or creating DNS.
i need a way that user can access oracle data base form any pc without installing or creating anything
is there any way to do such thing ?


Thanks in Advance

You'll need at least a Provider to connect to DB via ADODB etc.

As far as I am aware, the one from MS didn't require Oracle client. However, it's been deprecated, so probably isn't wise to use this.
Oracle provided OLE DB provider requires installation of Oracle Client.

There may be others out there, but I haven't dealt with Oracle Db in years (Mostly MySQL, MariaDb, MS SQL these days).

However, depending on your Excel/Office license, connector to Oracle DB is built-in to new Get & Transform/PowerQuery (I believe Pro Plus license for Office 365 has it).