Here you can select the import mode and set the extent of the import.
Four Import modes are available:
Insert All - Inserts all the records from the source file to the target object
Insert New - Inserts records which are not in the target object yet, others are skipped
Update - Updates those records which already exist in the target object, others are skipped
Update or Insert - Updates existing records and inserts new records
To choose which columns to import data into, select them in the "Available/Selected Columns" lists and use the four buttons between the lists to move the columns back and forth.
When using any Import mode other than Insert All, you will be required to designate one or more Key Columns. If a particular record's Key Column values match those of a record already in the database, the matching record will be updated. Otherwise, the data will be placed into a new record. Choose Key columns by using the "up/down" buttons next to the "Selected Columns" list.
At the bottom of the window you can choose whether you want to import all the records in the file or only a certain number (starting from the top).
Once you are satisfied with the settings, click Start Import.
NOTE: If you want to save an import scenario for later use, it is recommended to do so at this step, immediately before or immediately after performing the actual import.
See also: