FAQ

EMS Data Import for MySQL is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, TXT and CSV files to MySQL Server 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. EMS 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.

First of all you must have an opportunity to connect to some local or remote MySQL server. Besides you need your computer to satisfy the system requirements of EMS Data Import for MySQL.

You can configure the template files for each table or export type visually using the Data Import Wizard. Set the required import options on Step 3 of the wizard and click the ‘Save Import Options‘button. All the options will be saved to the template file, which can be used by the console application.

EMS Data Import for MySQL includes some additional features, which are not available in EMS SQL Manager for MySQL such as:

  • Import data to several tables at once;
  • Import data to tables selected from different databases on one host;
  • Command line utility to Import data using the configuration file with all the Import options.

This is a limitation of the trial version which imports only 20% of all records. With a registered version all the records are processed.

This error is generated by MySQL server because you don't have privileges to connect to the server from your host. Please contact your database administrator to resolve this problem.