DTS Access to SQL Server date problem

[Janean]

I'm trying to convert a table from Access 2003 to SQL Server 2003.

I'm using the DTS in SQL Server, but I get this error about a date field:

Insert error, column 15 ('DateComplete', DBTYPE_DBTIMESTAMP), Status 6. Data Overflow. Invalid character value for cast specification.

Any help would be appreciated.

Thanks.

(I tried using the Access Upsizing wizard, but that also failed. And didn't give me a reason why, just said it failed.)

[r937]

from what little information you've provided, i would say that there is probably an invalid date value in the date field