I went to "Import External Data" > "New Database Query" Then chose oracle as the Data Source.
I exited from the Query Wizard and instead opened up my own SQL window in MS Query. I then copied a query that I run through Oracle and paste it in the window. I try to run it in there, with the purpose of sending it back to Excel. This works for some queries, but my more complex ones I get random errors that I have to debug with no direction on the problem
I did some debugging and realized that MS Query doesn't like me renaming columns (i.e. cant say 'SELECT ORDER_DATA as Orders,). Also learned that I can't keep the comments in. That helped.
Was still hoping to find a good resource that explains the syntax that does and does not work. I looked on Google for awhile and couldn't find a thing, figured I would try the forums.
Thanks
Bookmarks