Connect to Oracle via VBA with no password

[dhancy]

Hello,

I have a VBA script that connects to our Oracle database using this code:

With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _
        "OLEDB;Provider=OraOLEDB.Oracle;Password=xyz ;User ID=abc;Data Source=myDB"  _
         Destination:=Range("$A$1")).QueryTable

Recently our agency moved away from passwords in favor of single sign-on.

Now when we sign in the database in the traditional way, we use a generic user ID with no password.

How can I modify the above VBA to reflect this new single sign-on approach?

Thanks in advance!

Dennis