DateTimeConvertError

Specifies the action an access service takes when it encounters rows with date, time, or datetime data values that are out of range for the target datatype.

Syntax

DateTimeConvertError=[reject | null | default]

Default

reject

Values

  • reject rejects the row containing the error and issues a warning message.

  • null inserts a NULL into the column and issues a warning message.

  • default inserts the default date and time values, as configured in the DefaultDate and DefaultTime properties, into the column, and issues a warning message.