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

Subscribe to our news:
Partners
Testimonials
Frank Thomas: "The import function from Excel is brilliant! I was able to port a database from a foreign source into Excel and then import it directly into MySQL with your program".
Jeff Johnson: "Thanks for your help. I'm a big fan of your software. It's very useful".

More

Add your opinion

Data Wizard for MySQL online help

Prev Table of Contents Next

Data Export

Data Export wizard is a tool to save data from MySQL 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. To run the wizard, use the Run Data Export Wizard link at Home page.

 

The following formats are available:

Microsoft Office Excel 97-2003
Microsoft Office Excel 2007
CSV, TSV, and DSV
HTML
XML
Text files (fixed-width columns)
Microsoft Office Word 97-2003
Microsoft Office Word 2007
Microsoft Office Access;
OpenDocument Spreadsheet
OpenDocument Text
DBF
PDF
RTF
DIF
SYLK
LaTeX
JSON.

 

To export your data,

Set connection properties for the source MySQL database;
Select the format to use for the output;
Select objects you want to export data from;
Select columns you want to include into result files;

 

See also: Templates



Prev Table of Contents Next