Easily export data from MS Sql Server to Microsoft Excel XLSX with no commerical licensing complications.
Download the latest release and run the installer. Unless you change the path, it will install to C:\Program Files\Laim McKenzie\Sql2Xlsx\.
Once installed, open Sql2Xlsx.exe and connect to your SQL Server. If you use a non-standard SQL Port, enter your SQL Server as SQLSERVER,10130 or SQLSERVER\INSTANCE,10130, additional parameters can be added by doing ;parametername=value, for example SQLSERVER,10130;Connection Timeout=100.
- Direct connect to SQL Server
- Quick export of data to Microsoft Excel Workbooks (xlsx)
- Use as a standard SQL 探索r if you don't want to install SMSS
- EPPlus for the Excel Exporting Library
- Stackoverflow as always
- SQL Icon made by Iconixar from Flaticon
- Paul Kohler