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

Subscribe to our news:
Partners
Testimonials
Jeff Johnson: "Thanks for your help. I'm a big fan of your software. It's very useful".
Samuel Poole: "I recently downloaded and ordered MySQL Data Wizard, and I thought I would drop you a note to let you know that it is the software I needed . Well done, keep up the good work, and please accept my very best regards. Please feel free to use the contents of this e-mail along with my name, as an endorsement of your excellent product".

More

Add your opinion

Data Wizard for MySQL online help

Prev Table of Contents Next

Data Import

Data Import wizard provides you with a graphical user interface to import data from the most popular files formats into existing MySQL tables. It allows you to adjust data formats, empty target tables, execute custom SQL scripts, etc. To run the wizard, use the Run Data Import Wizard link at Home page.

 

The following formats are supported:
 

Microsoft Office Excel 95-2003
Microsoft Office Excel 2007
Microsoft Office Access
Microsoft Office Access 2007
Delimiter-separated values (CSV, DSV, TSV);
Text files (Fixed-width columns)
DBF
XML
ODBC data source (any data source accessible via ODBC driver or OLE DB provider such as SQL Server, Oracle, MySQL, MS Access, Text files, MS Excel, etc).

 

To import data,

Set connection properties of the database to import data to;
Select the format to use for the input data;
Select the tables where you want to import the data;

 

See also: Templates



Prev Table of Contents Next