Bulk-copy transfer errors and express transfer errors are handled in different ways.
Express transfer does not support errors regarding individual rows. If an error occurs, the entire transfer is aborted. Any value errors that occur are handled by the ODBC driver.
Bulk-copy transfer errors are handled by the access service. Value errors occur during transfer processing when the value being inserted is out of range for the column datatype.