Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Data
Message
 
 
To
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:
01281301
Views:
11
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform