APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect to Oracle DB with Excel VBA

NicholasZhangJul 1 2016 — edited Jul 2 2016

Hi Guys,

I have below information about the oracle DB.
Could anybody tell how I can connect to the DB with excel VBA? Thanks a lot!

Provider=OraOLEDB.Oracle.1;Password=pwd;Persist Security Info=True;User ID=UID;Data Source="(DESCRIPTION=

(ENABLE=BROKEN)(load_balance = yes)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.com)(PORT=1234)))(CONNECT_DATA=(SID=SNAME2)(SERVER=DEDICATED)))";Extended Properties="FetchSize=60000"

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2016

Added on Jul 1 2016

#apex-discussions

6 comments

7,477 views