Hi Perry,
I'm glad you got it working.
>I figured it out. There were a couple tables with bad dates. We are good to go now. Thanks for all the help.
>
>>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.
--sb--