How to connect to Oracle database from Microsoft Excel | Import data into Excel from database tables

[@martinpaquette394]

Thank you!!!!! Exactly the help I was looking for...👍

[@oracle_professor]

Great!

[@jimlewis4389]

Very clear instructions which worked. Thanks!

[@Pr0x1mo]

So i don't have the option to add "From Oracle Database" ?

[@oracle_professor]

You skipped the video and did not view it completely

[@Pr0x1mo]

@@oracle_professor No i didn't. You just go to the data, then under the db's, yours has oracle listed, mine doesnt.

[@oracle_professor]

@@Pr0x1mo I've got the Ofice 2021.

[@diyxpert5136]

Thanks it really worked however in my case what was missing is Servername/SID. I tried using this but I was getting some listener error. Then I added port name and it looked likeServername:1660/SID (1660 was the port name) and it worked like a charm

[@fip4070]

Thank you Broo