I have a VBA script that have been using for several years to connect to our Oracle database. It looks like this:
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _
"OLEDB;Provider=OraOLEDB.Oracle; Password=myPW; User ID=myUser; Data Source=myDB", _...