I've been using (and loving) version 8.0 for months now, and really like the "Copy to Excel..." feature - it is heavily used by everyone in my department. However the format of the "SQL Statement" sheet could be better, it tries to put then entire query into a single cell, which is difficult to work with and often chops long queries (yes, Excel 2003 still, I know). Wouldn't it be better to put each row of the query into it's own cell, all in column A? You might have to replace Tab characters with a pair of spaces or Excel will start putting in columns B, C, etc - which is definitely NOT desirable. It would be great if the font color were set like the syntax highlighting, at least for comments, like in pld.
SQL format on "Copy to Excel..."
- Thread starter Kirk W
- Start date
And a minor request if this is changed, the sheetnames could just be "Results" and "SQL" instead of "SQL Results" and "SQL Statement". If you really want to get Finance people excited (who doesn't enjoy that?), allow multiple result sets to be exported to Excel together - like all the tabs when multiple queries are run in a single SQL Window.
I have added this to the list of enhancement requests.
Similar threads
- Discussion