Bulk copy transfer errors and express transfer errors are handled differently:
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.