EMS logo

Products Navigation

Data Import for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Import for InterBase/Firebird

On-line Documentation

Add/Edit Range


To set a range of data to be imported from the file, use the Add range btnAddRange button.

To remove a range, use the Delete range btnDeleteRange button.

 

To edit an existing range, double-click it in the Ranges list. The Range dialog allows you to set a number of options for the range being edited.

 

Mapping fields - Excel - Range

 

 

Select Range Type from the corresponding drop-down list. Then specify the column, row or cell number whose range is to be defined.

Start and Finish section allows you to set the range of the values to be imported from the specified row or column.

Use the RadioButton From Data Starting and RadioButton While Data Exist options to automatically define the range of the values.

If neither start row/column nor finish row/column was specified you need to set range direction: RadioButton Down or RadioButton Up for column range and RadioButton Right or RadioButton Left for row range.

Use Sheet section to define the location of the row/column for which the row was specified.

You can select either RadioButton Default sheet, or RadioButton Custom Sheet.

For custom sheet you need to select Sheet Number or Sheet Name from the appropriate drop-down list.

 

Note: If Cell was set as Range Type, the only thing you can specify at this dialog is its number.