CODEWITHSUNDEEP
exceloracle-sqldeveloper
user8340125
user8340125

Reputation:

Run oracle sql query in excel?

Is it possible to have the queries I have written in developer run in excel? I can connect to the db in excel but I'm unsure of how to find and run the queries.

Upvotes: 1

Views: 6670

Answers (1)

McGlothlin
McGlothlin

Reputation: 2099

Check out this page.

Once you're able to connect, you should be able to query the database in its native language. Select the Power Query tab, then the drop-down From Database -> From Oracle Database. Simply copy/paste your existing Oracle query into the SQL Statement box and you should be good to go.

In case you don't already have it, Power Query is an add-in for Excel. You can find it here.

Upvotes: 1

Related Questions