I wrote a routine that cycles thru a list of tables.

1) It looks for date fields in each table.
2) For each date field, it checks to see if the date field is nullable, if not it makes it so
3) Then it replaces empty dates with null


This works like a champ, almost. I went from 12 tables with errors to 2. Do you have any suggestions as to what could still be causing a problem?

Thanks

>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.