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

Microsoft Excel has a perfect possibility of running direct database queries and using results for further processing: as a simple data table or as a base for Pivot tables and Charts. However, you have some clicks to do before your query gets executed in Excel. SSMSBoost allows you to do it all in one click:

  • Select the query that you need to export for execution to Excel
  • Execute SSMSBoost->Query->Run in MS Excel command

  • SSMSBoost will create a Database Query (*.dqy) file containing selected SQL Statement and current connection information
  • *.dqy file will be passed to Excel for further processing. You may be prompted to adjust security settings in Excel to allow the processing of "*.dqy" files
Note: Excel has some requirements that your query has to meet. You can find a detailed documentation on the Internet but to keep it short: it must be a single SQL query returning one dataset.

IMPORTANT: Make sure you check SSMSBoost->Settings->Database Query (.dqy) for fine-tuning options.

SSMSBoost can export connection password in clear text form for SQL Server native authentication which might be a big problem if you are going to share your *.dqy file with someone else. And yes - this is a workaround of how to restore a forgotten SQL Password for some connection that is still present in your recent connections list.