Error-handling options

The Data Loader has comprehensive options for handling errors during the load process. Errors are split into two types, as you may wish to have different options for handling each:

duplicate-row errors

occur when you try and load a row into the table that already exists (as specified by the unique key(s) on the table).

Note that for some databases this error will also happen when a row cannot be loaded because of a foreign-key constraint (some databases return the same error code as the code for unique-key error).

other errors

covers all other errors

For both of these error types, you can specify the action to take when the errors are encountered:

whether the Data Loader is to Continue processing or is to stop
after how many errors the processing is to stop. This allows you to specify an acceptable number of errors.
whether AQT is to Commit or Rollback after getting these errors. This option will be available only if the Commit frequency is set to Once finished or Every xx rows. Do not use these two options for MS Access tables, which do not fully support commit.

When any errors occur they are written to the Error Report file. Any records that fail to be loaded are written to the Duplicate Row and Error Rows files. These records are written in csv format (comma delimited, with strings delimited with double-quotes) irrespective of the source of the data.