EMS Data Import for MySQL 3.2

EMS Data Import for MySQL 3.2 is an application designed for importing data to quickly from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files MySQL table.

EMS Data Import for MySQL offers the adjustable import parameters such as source data formats for all the fields and destination MySQL data formats for the selected fields, commit options, number of records to skip. This tool also provides a wizard enabling you to set all the MySQL import options for different files visually, and a command-line utility to quickly execute import to MySQL database.

Major Features:

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

Enhancements:

• Added the possibility to create separate tables for each source data file. The table structure is built on the basis of the source data analysis.
• It is now possible to specify the source data charset when importing TXT and CSV files.
• The ability to set correspondences between source data and existing table fields is implemented. This correspondence is based on the identity of the source columns’ and destination table fields’ names.
• Added the possibility to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
• SQL Server 2008 support is implemented.
• PostgreSQL 8.3 support is implemented.
• Destination table fields' types are now displayed. (DB2)
• The "Automatically reconnect when connection is lost" option is added. (MySQL)
• Added the possibility to set the Connection Timeout parameter before connecting to the host. (SQL Server)
• Importing data in the Universal mode resulted in error. Fixed now. (DB2)
• Using "-log" parameter in console versions used to result in error. Fixed now.
• Other minor improvements and bug fixes.

Requirements: