Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Richard Finner: "Thanks. I have paid my money. I experimented with many trial copies of similar programs and found your SQLite Data Wizard to be ingenious yet simple. It suits my working style".
Stephan Hennekens: "Excelent tools!!! Suberb design and interface. I have just pumped an Access database into a SQLite database. All the data including the indexes with just a few clicks".

More

Add your opinion

SQLite 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.

 

 

HTML

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