Export query results enhancement request

[Michael D]

Hello,

When I execute multiple queries in an SQL window, so the results show up in multiple tabs, each tab has it's own toolbar with a button to export the results to a file, e.g. an Excel file.

Queries in a multi-query window are usually related, and are likely to be needed in a single file. It takes some copy-pasting to achieve that.

My enhancement request would be to have an option to export all tabs into one file for supported file types. In particular, that would be an Excel file with a tab for each tab in the query results.

Thank you in advance.

Best regards,
Michael Doel
Truston Solutions

 

[Marco Kalter]

If you have multiple result sets in a SQL Window, you can right-click on a result set, select "Copy to Excel", and select "Copy all as xls" or "Copy all as xlsx". Now each result set will be copied to a separate Excel sheet in one file.

You can additionally use the TAB= comment directive to define the Excel sheet name for each query.