Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Data
Message
From
11/01/2008 21:52:09
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01281057
Message ID:
01281297
Views:
10
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.

(On an infant's shirt): Already smarter than Bush
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform