EMS Data Import for MySQL can easily and quickly import data from various file formats such as Excel, Access, and CSV to MySQL tables with ease. It supports different file types such as TXT, XML, HTML and RTF with a simple user interface.
One of the best features of Data Import for MySQL is its user-friendly wizard. It guides users on how to set different MySQL import options for various files visually. Moreover, it includes a command-line utility for one-touch execution of import to the MySQL database.
This software has several import modes, namely Insert All, Insert New, Insert or Update, and others. Additionally, it provides special batch insert commands that enable users to import data at the maximum possible speed. Furthermore, Data Import for MySQL supports secure shell (SSH) and HTTP tunneling and contains an automatic creation of the table structure.
Users can adjust the import parameters for each source file and save all the import parameters set for the current wizard session. They can also use the command-line utility to import data using the configuration file. Lastly, Data Import for MySQL includes a powerful visual options module.
Overall, EMS Data Import for MySQL is an essential tool for users who need to import data to MySQL tables quickly and effortlessly from different file formats. It is user-friendly, efficient, and provides various options for import modes, parameters, and structure.
Version 3.3:
Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
Other improvements and bugfixes.
Version 3.2:
- Added the possibility to create separate tables for each source data file; to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
- It is now possible to specify the source data charset when importing TXT and CSV files.
and much more...
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.0:
- 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 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.0:
- 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.1: - Added Portuguese language support, decreased processor loading while executing long operations and more...