EMS Data Import for MySQL

What is EMS Data Import for MySQL?

EMS Data Import for MySQL is a powerful tool for quickly importing data into MySQL tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, and HTML files.

It provides adjustable import parameters, including source data formats for all fields and target EMS Data Import for MySQL data formats for the selected fields, commit options, number of records to ignore. Data Import for EMS Data Import for MySQL includes a wizard, which allows you to set all MySQL Import Options for different files visually, and a command-line utility to perform the import to the MySQL database at one touch.

Key features of EMS Data Import for MySQL

• Import from the 10 most popular formats: MS Excel, MS Access, XML, DBF, TXT, CSV, MS Word, OpenDocument Format, and HTML.
• Importing data to one or more tables or visualizations from different databases.
• Special batch insertion commands allow you to import data at the maximum possible speed.
• Multiple import modes - Insert all, insert new, insert or update and others
• Secure Shell (SSH) and HTTP encapsulation support.
• UNICODE support.
• Adjustable import parameters for each source file.
• Saving all import parameters defined in the current wizard session.
• Automatic creation of the table structure.
• Command-line utility for importing data using the configuration file.
• Powerful module of visual options.
• Amazon RDS support for MySQL/MariaDB, Amazon Aurora, Percona server.

System requirements

Microsoft Windows XP, Microsoft Windows 2003 Server, Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 8.1, Microsoft Windows 10

512 MB of RAM or more

50 MB of available HD space for program installation

Possibility to connect to any local or remote MySQL server