When using DTS to import Access Database (with one column
of Date/Time type data "08/08/1111") into SQL Server 2000
database, error message show:

"The number of failing rows exceeds the maximum
specified. Insert error, column 2 ('Time',
DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid
character value for cast specification"

"08/08/1111" is invalid? Why it is allowed in Access 2000,
but not allowed in SQL Server 2000. Is it a bug.

Best Regards,

Henry