EMS Data Import for MySQL is a powerful tool to import data to MySQL tables quickly from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination MySQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for MySQL includes a wizard, which allows you to set all the MySQL import options for different files visually, and a command-line utility to execute import to MySQL database in one-touch.

Key Features

* Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML
* Importing data to one or several tables or views from different databases
* Special batch insert commands allow to import data at the maximum possible speed
* A number of import modes - Insert All, Insert New, Insert or Update, and others
* Secure Shell (SSH) and HTTP tunneling support
* UNICODE support
* Adjustable import parameters for each source file
* Saving all import parameters set on current wizard session
* Automatic creation of the table structure
* Command-line utility to import data using the configuration file
* Powerful visual options module

Keywords: import mysql database, mysql database import, import mysql data, mysql import tool, import data to mysql database, import access to mysql, import excel to mysql, import csv to mysql, import txt to mysql, import xls to mysql, import xml to mysql,

Recent Changes: Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
Other improvements and bugfixes.

Install Support: Install and Uninstall

Supported Languages: English, French, German, Italian, Portuguese, Russian, Spanish

Additional Requirements: Pentium 300; 32 MB RAM; Possibility to connect to some local or remote MySQL Database Server

PAD file URL: http://www.sqlmanager.net/pad/mysqlimport_win_pad.xml