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

Subscribe to our news:
Partners
Testimonials
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".
Mark Worsnop: "By the way I wanted to say thank you for a good software package. It's a pleasure to work with Maestro as it "just works" and makes my job that much easier".

More

Add your opinion

SQLite Maestro online Help

Prev Return to chapter overview Next

Export Data Wizard

Data Export wizard is a tool to save data from SQLite  tables, views, and queries to the most popular formats. It allows you to fully customize output files including header and footer, fonts, colors, and data formats.

 

Export Data tool supports:

Microsoft Office Excel 97-2003, 2007
CSV
HTML
XML
Text
Microsoft Office Word 97-2003, 2007
Microsoft Office Access
OpenDocument Spreadsheet
OpenDocument Text
DBF
PDF
RTF
DIF
SYLK
LaTex.

 

In order to run the wizard you should either

 

open the table in Table Editor;
go on to the Data tab

or

open and execute the query in SQL Editor or Query Builder;
proceed to the Result tab

 

and select the Export Data item from the Navigation Bar.

 

To export your data,

Set the format and the name of the destination file;
Specify such additional options of the result file as header and footer, formats applied to exported data and some format-specific options;
Select columns you want to include into result files;

 

See also: Get SQL Dump, Import Data Wizard



Prev Return to chapter overview Next