How to connect to Oracle Database from Excel

[gurusamyselvan]

HI

1. We are using oracle database 11g.
2. Widows 8.1 64 Bit OS
3. MS office -2013 32 Bit.

• We want to connect to database and run a query.
• Can i save the DB connection password without user entering every time when refresh the data.

Can you please provide the required steps to achieve this requirement.


Thanks

 

[sathish16]

Check this link:

https://support.office.com/en-us/ar...er-query-d7fbd231-a705-4eb7-83b3-a66bfb678395