EMS Data Import for MySQL 3.1
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 provides 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.
- 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
- A number of import modes - Insert All, Insert New, Insert or Update, and others
- 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
Version: 3.1(02 Oct 2007)
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile=source file name parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version: 3.0(23 Jan 2007)
- The new ?Native? method of import is added which includes two algorithms ? Single Commands and Batch Insert.
- Import from new formats.
- Utility source code significantly optimized, work speed increased.
- Unicode support.
- Other improvements and bugfixes.
Version: 2.2(30 Oct 2006)
- The ability to import data from VisualFoxPro DBF format added.
- The amount of memory consumed is significantly decreased when importing large files.
- Other improvements and bug-fixes.
Tags: | Access | Database | Import | Sql
|(mysqlimport.zip - 6.58 MB)|