Run selected script as Database Query (.dqy) in Excel

Microsoft Excel has a perfect possibility to run direct database queries and use results for further processing: as simple data table, as base for Pivot tables and Charts. However, there are some clicks to do, before you get your query executed in Excel.
SSMSBoost adds 1-click functionality to complete this:
  • Select query, that you want to export for execution in Excel
  • Execute SSMSBoost Menu->Query->Run in MS Excel command
  • SSMSBoost will create Database Query (.dqy) file, passing selected SQL Statement and current connection information
  • File is now passed to Excel for further processing. It might be necessary to adjust security settings in Excel to allow processing of ".dqy" files
Note: Excel has some rules, that your query must fulfill. You will find detailed documentation on the Internet, but to keep it short: it must be single SQL query, returning one dataset.

IMPORTANT: Make sure you check SSMSBoost Settings->Database Query (.dqy) for fine-tuning options. For SQL Server native authentication SSMSBoost can export connection password in clear text form, which might be a big problem, if you are going to give .dqy file to other persons. And yes - this is a workaround how to restore forgotten SQL Password for some connection, that is still present in your recent connections list.

SSMSBoost database query .dqy