This tool helps convert data from DB2 databases to Excel spreadsheets.
This utility can save time for users when exporting data to Excel formats. This MsSQLToExcel software is a data conversion tool that makes the transfer possible. You can choose to export a particular table from the database. It is possible to gather data for export through a query to the database. The interface presents different screens for arranging these transfers. The controls available are quite intuitive, and the IT types will be able to use the utility easily. The batch interface lets you export a batch of tables at a time. The sequence of operations starts with choosing a schema. Tables to be exported are then selected by simply ticking the corresponding check boxes. This tool works in Windows environment and with versions like Windows 2000, XP, 2003, Vista, 2008, 7, 8.
Session parameters are set by the user. These can be saved for reuse later so that you do not need to set up these parameters again and again for similar sessions at different times. The transfer session can start moving the data to the Excel table. A progress bar shows you how much of the transfer has been completed at a time. Number of records transferred and remaining amount yet to be transferred are also indicated. Thus, if there are transfers you do regularly, load and save session parameters can be a tool to help save a significant amount of time. The command line interface can be used to set up transfers easily. These transfer sessions could be scheduled to be done at specific times. This is a very good tool.