EMS logo

Products Navigation

Data Import for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Import for MySQL

On-line Documentation

Step 2 - Selecting files to import


At this step you should select source file(s) to be imported.

 

Click the iconAddFile Add File button to select the source file name using the Open file... dialog. Repeat this operation to add more source files (if necessary).

You can choose among the following types of the source data file:

  • MS Excel
  • MS Excel 2007
  • MS Word 2007
  • MS Access
  • DBF
  • TXT
  • CSV
  • HTML
  • XML Data Pack
  • XML Doc
  • ODS
  • ODT

 

The open file dialog allows you to set a filter on the source file format.

To delete a file from the list, select it and click the iconRemoveFile Remove File button.

 

You can also change the order of the source files in the list using the Up btnMoveUp and the Down btnMoveDown buttons.

 

Step 2

 

 

Note: For the spreadsheet files: if you need to import data from different sheets into different tables you are to include that multi-sheet spreadsheet file into the list several times (equal to the number of sheets to be imported to different tables).

 

When a file is selected the Select Table dialog appears:

 

Select table dialog

 

 

File name field displays the selected file name and its location.

Database field allows you to specify the target database.

 

RadioButton Insert into existing table

Select this option to import data to the existing table. Tables area contains the list of tables in the selected database. You can refresh the list by clicking the Refresh button.

RadioButton Create new table

Use this option to create import destination table.

 

To change the target MySQL table that has been already assigned to a source data file, select the table in the list and press the ellipsis btnEllipsis button to call the Select Table dialog again.

 

 

When you are done, press the Next button to proceed to the next step.