EMS Data Import for MySQL 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.
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.
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 Data Import for MySQL":
· 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
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
· MySQL server versions: from 3.23 up to 6.0
Limitations:
· 30 day trial
· The trial version is limited to importing 20% rows of the source data file.
· Nag screen
What's New in This Release: [ read full changelog ]
· Added the support of Microsoft Office Access 2007 files
· The work with data is more convenient now. Templates for basic date formats are added
· Now when importing from an Access file to a new table, the structure of any Access table from a file is created
· Added the support of complicated date templates: mmm dd yyyy hh:nn:ss:zzzAP or yyyy-mm-ddThh:nn:ss.zzz
· Now it is possible to set BigInteger (64bit, 19 Decimal digits) values for the generator at step 5 of the utility
· Some other improvements and bugfixes
Find us on Google+
