Home Forums Article Discussions Article Discussions by Author Discuss content posted by Darko Martinovic Query to Excel Stored Procedure RE: Query to Excel Stored Procedure
March 5, 2018 at 10:54 am
jbowers - Monday, March 5, 2018 9:12 AMDarko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File, and now... Results to Excel?!? When I got to the line "...SpreadSheetGear is commercial software that cannot be distributed without license", I popped over to https://www.spreadsheetgear.com/downloads/purchase.aspx to learn that their licenses go for $999. I can buy an Excel license for $129.99, which got me thinking, "Why would I ever want to do this instead of just copying the query results from the SSMS grid and pasting it into a blank Excel workbook, where I can then manipulate it further?"I was intrigued by the premise, which is why I read the article. You did a great job of documenting all of the of very detailed steps required to make this work. But I'm curious as to what you think the real-world application of this technique would be.
The reviews of Excel 2016 were comically bad. Wow.
412-977-3526 call/text