Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to SQL Import Errors
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01008543
Message ID:
01008942
Views:
14
Kevin,

The date in the 'actdate' column in the row 157 is invalid: '11/28/0200'. After I changed it
to '11/28/2000' import finished successfuly.

>On its way now
>
>>Can you zip up and send me a table with the first 300 records?
>>
>>>The text of the error is:
>>>
>>>"Error at destination for row number 157. Errors encountered so far in this task: 1.
>>>Insert error, column 12('actdate', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
>>>Invalid character value for cast specification"
>>>
>>>I went to record 157 and I don't see anything wrong.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform