Sql2Xlsx
Information
Easily export data from MS Sql Server to Microsoft Excel XLSX with no commercial licensing complications.
Installation & Usage
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
.
Features
- Direct connect to SQL Server
- Quick export of data to Microsoft Excel Workbooks (xlsx)
- Use as a standard SQL Explorer if you don’t want to install SMSS
Screenshots
Credits
- EPPlus for the Excel Exporting Library
- Stackoverflow as always
- SQL Icon made by Iconixar from Flaticon
- Paul Kohler