Online Documentation for SQL Management Studio for MySQL

Running Data Import

EMS Data Import for MySQL is a powerful program to import your data quickly from MS Excel, MS Access, DBF, TXT and CSV files to MySQL tables.

Data Import for MySQL provides you with an easy-to-use Wizard that guides you through all the steps of the data import process: you can set import parameters, including source data formats for all fields and destination data formats for selected fields, commit options, number of records to skip, import mode, etc.

In addition to the GUI version, which is implemented as a Wizard application, Data Import for MySQL includes a console version intended to run from the Windows command line with a template file name used as the execution parameter.

To run Data Import for MySQL, click its icon or caption in the Data Manipulation section and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu, where you can specify a template and then run the wizard/console with the template.

To manage configuration files (templates), use the corresponding Manage templates link. In this case, you will be redirected to the Template Management section of SQL Studio.