Connecting to Oracle Database & use SQL script in the Command Text NOT Power Query

[elevate_yourself]

Hi All,

I am trying to setup an Oracle database connection to pull a specific set of data into my spreadsheet. I can connect to the database however in older versions of Excel I was able to add the SQL statement I need into the Command Text of the Connection Properties. Now however, excel is forcing me to use the Power Query editor as I setup the connection which is less than ideal because Power Query does not preserve the SQL script in a way that can be easily seen by other users who are not as excel literate.

Is there a way to still set up the connection so that I can just add the SQL script into the Command Text box or is using the Power Query the only way now?


Thanks!

[AB33]

You still can use the old version, but as you find out yourself, Excel forces you to use Power Query.
MS has been stopping supporting IE since over a year ago, but you can still use IE. IE is dead and Edge is not incorporated in VBA and unlikely in the future.
Unless you want to extract table with refresh ability, you can write raw SQL using ADDOB object.

Please Login or Register  to view this content.