Most likely the empty dates are responsible. Replace them with NULLs.


>I did get a 6 month contract to hire today. And it's at a competitor to my former scam company. My first task is to export data from the old VFP accting app to SQL Server.
>
>We are trying to do an Import thru SQL Server. But we are getting an error on date columns. I'm sure this has been discussed here before is there a way to fix this, or another way to transfer the data. The error is:
>
>Insert error......(column, dtype_dbtimestamp), status 6: data overflow. Invalid character value for cast specification
>
>
>Thanks.