EMS logo

Products Navigation

Data Import for MySQL

Our customers

Testimonials

Although it's been available for a while now, I’ve just tried the Advanced Query Builder for the first time, and it's awesome!!!! Thanks for making such a great product! Thanks again.
Athanasios Alekizoglou
Qualisys Information Technology System

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

News

11/29/2018
EMS Data Import version 3.8.3 released
Improvements and fixes in the console version, fixes of data import errors in the GUI version and more...
08/30/2017
EMS Data Import version 3.8.2 released
Improved processing of big files, added option for after script execution, fixes for NULL values import and data from XLSX additional sheets and much more...
04/14/2016
EMS Data Import version 3.8.1 released
Fixes for importing XLSX files, latest OpenSSH support and more...
03/09/2016
EMS Data Import version 3.8 released
XML, Microsoft Office and Open Office files are processed and imported much faster now, fixes for processing object names, data type conversion and much more...
06/09/2014
EMS Data Import version 3.7 released
Import rate is increased; added the possibility of manual and automated identification of the type of the imported XML-file, and much more…
07/04/2012
EMS Data Import version 3.6 released
Added the "Import Empty Rows" and "Auto Trim Values" options, and much more…
News Subscribe | More News
twitterfacebookXML content. Requires RSS support to view.

EMS Data Import for MySQL

Overview

Download!
Buy online!

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
  • Support of Amazon RDS for MySQL/MariaDB, Amazon Aurora, Percona server

In-purchase benefits

  • FREE One Year of Maintenance already included!
  • FREE software updates and upgrades during Maintenance period!
  • FREE and unlimited Technical Support during Maintenance period!
  • Reasonable pricing for Maintenance renewal – from 35% per Year!
  • Volume discounts when buying two or more copies of one product
  • Cross-selling discounts on related products
  • 30-day money-back guarantee

Product Screenshots

Enlarge

User-friendly wizard interface
Step 2 - Selecting source files

Available Versions

Data Import for MySQL
EMS Data Import for MySQL is a powerful tool to import your data quickly from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word, ODF and HTML files to MySQL tables.

Available Interface Languages

English
English
German
German
French
French
Russian
Russian