Helps you import data from MS Excel, MS Access, DBF, TXT, CSV, XML files to MySQL table EMS Data Import for MySQL is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to MySQL tables.
It will provide adjustable import parameters, including source data formats for all the fields and destination 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 import options for different files visually, and a command-line utility to execute import in one-touch.
Here are some key features of "EMS MySQL Data Import":
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
Command-line utility to import data using the configuration file
Powerful visual options module
User-friendly wizard interface
Requirements:
300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
64 MB of RAM or more; 128 MB or more recommended
20MB of available HD space for program installation
Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
Microsoft Mouse or compatible pointing device
Possibility to connect to any local or remote MySQL server
Limitations:
30 day trial
The trial version is limited to importing 20% rows of the source data file.
EMS MySQL Data Import
Advanced Data Import
EMS Data Import 2007 for SQL Server
EMS Data Import for InterBase Firebird
EMS Data Import for Oracle