View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Olivier Rollet Olivier Rollet is offline
external usenet poster
 
Posts: 1
Default 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.