Online Documentation for SQL Manager for DB2
Export Data Wizard
Export Data Wizard allows you to export data from a table / view or from a query result to any of supported formats (MS Excel, MS Access, MS Word, RTF, HTML, PDF, TXT, CSV, XML, DBF, MS Excel 2007, MS Word 2007, etc.). You can save your settings as a template any time for future use.
To start the wizard, right-click the object in DB Explorer and select the Data Manipulation | 
Export Data... context menu item.
Alternatively, you can open the Data tab of Table Editor / View Editor or the Result(s) tab of SQL Editor / Query Builder, right-click the grid there and select the Data Manipulation | Export Data of <object_name>... context menu item.
- Setting name and format for the destination file
- Selecting fields for export
- Adjusting formats applied to exported data
- Setting header and footer text for the destination file
- Setting format-specific options
- Setting common export options
- Exporting data
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
