I would like to export results to Excel directly
In the result window, right click and select all and have an option to export selection to Excel (new spreadsheet) or to an open spreadsheet at the current location.
3
votes
Larry Meklemburg
shared this idea
This is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
AdminDavid Priddle
(Admin, Redgate)
commented
Hi Jordan - we noticed this as well and have fixed it in our beta: https://forums.red-gate.com/viewtopic.php?f=169&t=79994
Please let us know if this works for you.
-
Jordan Knapp
commented
It would be nice if the cancel button actually canceled the export.
-
BRutter
commented
This works great! Could we have an option to show NULL as just a blank space in Excel? I rarely want "NULL" in my Excel files. Thanks!!
-
Larry Meklemburg
commented
Great Idea, but really got it from Toad for SQL Server and I've used it quite often.