Editor's review
This software tool helps with export of data from MS SQL Server database to Excel spreadsheets.
Withdata MsSqlToExcel is a tool to export MS SQL Server data to Excel file. The tool is configured very easily through visual tools. The progress of the data export process is easily visible with an indication of time remaining. By exporting tables and queries as well as multiple tables at any one time the tool can be a huge time saver. The program is able to handle both XLS and XLSX formats of the Excel 2003 and 2007 versions respectively You. can decide to have all the tables in one excel file in multiple sheets. All data types are supported including text, ntext, varchar. If the data to be exported is large, and needs automation you can use command line execution as well as scheduled execution of the data transfer projects.
When exporting data you can choose to transfer all the fields of the data or selected ones from the tables. Choosing these is as simple as ticking the right check boxes on the interface. The menu options let you select export from table, all tables, queries, etc. File manipulation menu will allow you to save a session for later reuse too. Define export data formats, specify if you need Unicode encoding of the text characters and finally if you need Excel 2003 or 2007 version. The progress bar shows the elapsed time as well as time remaining. The same progress area has another tab that holds the log of events. Should there be any problems, the log message would clue you into a solution too. If this is a task you do many times in the enterprise, this tool can save you a ton of staff tome and hence money. Give it a try!
User comments