Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Josh Armstrong: "I absolutely love this software! It will me take our migration time down by an order of magnitude. It has especially helped with my indexing as my database contains many complex ones".
Michael Pavitsky: "SQL Maestro Group provided the kind of services and support for managing PostgreSQL data expected in a true business partnership. Their devotion to customer satisfaction and cost curtailment is a pleasure for PostgreSQL users. I wouldn?t hesitate to recommend PostgreSQL Data Wizard to any of my peers and I know and trust they will surpass all expectations".


Add your opinion

PostgreSQL Data Wizard online Help

Prev Return to chapter overview Next

Setting format-specific options

Each format supposes corresponding additional export options. Use the wizard option to adjust export properties depending on the target file format you have selected earlier. The following formats are at your disposal: Microsoft Excel, Microsoft Excel 2007, CSV, Text, HTML, XML, Microsoft Word, Microsoft Word 2007, Microsoft Access, OpenDocument Spreadsheet, OpenDocument Text, DBF, PDF, RTF, DIF, SYLK, and LaTeX.


Microsoft Excel

The Data Format tab contains general options, which allow you to adjust the format for each kind of Excel cells. This means that you can specify such parameters as font, borders, filling color and method, etc. for each entity (such as data field, header, footer, caption, data, hyperlink and so on) separately. Also it is possible to create styles to make target Excel file be striped by columns or rows (the Styles tab).


The Extensions tab provides a possibility to add hyperlinks and notes to any cell of target file. Click the Plus button to add a new hyperlink or note to target Excel sheet and adjust its parameters. Click the Minus button to delete added hyperlink or note.


The Advanced tab allows you to define page header, page footer and title for target Excel sheet.




The Preview tab allows you to select the style of HTML file from a number of built-in templates provided by the Templates combo box. You can choose any of these templates, customize it by clicking on objects in the preview panel, and save it as a custom template using the Save template button. Use the Load template button to load previously saved custom templates from hard disk.


The Basic tab allows you to specify basic parameters of target HTML file, such as its title, cascade style sheet options, etc.


The Multi-file tab provides you with a possibility to split target HTML file into several separated files. This tab allows you to specify the record count for a single file, set an option to generate an index HTML file, and add an ability of navigation between each other to each of exported files.


The Advanced tab contains such HTML options as default font, background, cell padding and spacing, etc.



Text files

Set the Calculate column width options on if you want each column of target file to be adjusted to the maximum number of characters in it. The Spacing option specifies the number of spaces between columns in the target file.



CSV files

You can specify column separator and optional values quote character for the target file on this step.



XML documents

Specify XML document encoding in the Encoding edit box and set the Standalone option on if you wish the target document to be standalone.


Prev Return to chapter overview Next