1

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.

Improve this question

1 Answer 1

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Thanks. When I do that I get a window that says "This connector is not configured correctly. The recommended provider is not installed." Is that ok?
Sounds like something's not set up right, but upon googling I see that error appears to be from Power BI not from Power Query. Take a look at this: support.office.com/en-us/article/…
What button do I hit to get the area to paste the sql statement?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.