Online Documentation for SQL Manager for SQL server
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, select the Data Manipulation context menu group and proceed to the Export Data... item within this group.
Alternatively, you can open the Data tab of Table Editor / View Editor or the Result(s) tab of Query Data / Design Query, right-click the grid there, then select the Data Manipulation context menu group and proceed to the Export Data of <object_name>... item within this group, or use the Export Data item of the Navigation bar.
- Setting name and format for the destination file
- Selecting columns 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. |