ExcelBanter - View Single Post - Stop to modify the SQL query manually entered into query !

Jamie Collins

"Olivier Rollet" <Olivier wrote ...

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.

Try using the more 'modern' ADO in VBA code - no GUI tools or wizards
to mess with your SQL code! Better still, write a server side stored
procedure and simply pass the required parameters from Excel - no SQL
on the client side!

Jamie.

--