In Microsoft SQL Server we have the SQL Server Export Wizzard that enables us to export MS Excel files.

But it's...  a little bit annoying to say at least.  Yes, all of the wizzards build into MS SQL Server are capeable of doing their job. The concerns are more about the "how":

  • We are running on WQHD or even 4K screen resolutions, yet the various wizzard interfaces are very tiny with their 8px font - even on a standard 1080p resolution.  Resizing the wizzard dialog window to usefull dimensions where you don't have to scroll miles? Of course this is not possible...
  • You're logged into a SQL Server instance where you want to export stuff and the first thing in the export wizzard is - selecting the server instance from which data should be exported.  Hello MSFT? Why don't you take the current server instance as a default with the option to choose a different one?
  • You don't want to simply export a table but rather would like to export the result of a complex query? No problem - create a view and export it - one more additional step, one more thing to get ride of afterwards.
  • Then we have to map each single column. But even by doing so MS Excel sometimes really gets into big troubles interpreting a simple DateTime value.

That's much too much headache for such a simple and recurring task - I have that SQL query X, put the result field in a useable Excel sheet. Period. 

No need to waste minutes after minutes any longer for that simple task thanks to SqlQuery2Excel!


SqlQuery2Excel comes with a built in Project Management:

Save you current SQL query with the current credentials for future usage.  Of course, because security matters, all of your sensitive data will be stored encrypted.