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.
(I tried using the Access Upsizing wizard, but that also failed. And didn't give me a reason why, just said it failed.)