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

Subscribe to our news:
Partners
Testimonials
Rati Dzidziguri: "I'm working on development of ERP and CRM software and during the process of creation of those products I have tried lots of solutions by the only solution I would call as an user friendly professional and with many other epithets is MySQL Maestro and all Maestro toolkits".
Prithwi Thakuria: "I have been in the database field for eons. This is one the best suite of tools I have found in terms of cost, functionality and performance. Ever since we bought this array of products, life with databases have been a breeze and the productivity has soared immensely. Keep up the good work".

More

Add your opinion

Customers
Download Buy

SQL Maestro for MySQL online help

Prev Return to chapter overview Next

Export Data Wizard

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.

 

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