Stop to modify the SQL query manually entered into query !
with Oracle, when using functions in a manual SQL query into Excel, the
alias for the ciolumns are SYTEMATICALLY ignored or dropped .
There is no workaround by trying to edit it via the GUI because the
genrarated SQL doesn't work ! So, it needs to write a macro to correct this.
Easy, but boring .
However, you should really think about do someting of this obsolete piece
of junk named MsQuery.
|