General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>Hi,
>>>
>>>When attempting to export a VFP Database to MS-SQL 2005 using the Upsize wizard I'm getting an error:"Error #10 in genbulkinserttextfile(0): syntax error".
>>>
>>>I've narrowed the problem down to a specific table. The table is created in MSSQL but no data is imported.
>>>
>>>I tried this on three databases with identical structure and one exported OK so I'm assuming the problem lies with the data content.
>>>
>>>I've tried the same thing with the Sedna CTP wizard and get basically the same error - except that it gives (2313) instead of (0).
>>>
>>>Any suggestions as to what the problem might be?
>>>TIA,
>>>Viv
>>
>>Check and fix your data
>
>Don't see any problem with the data - so what might need fixing?
2313 is error for difference in type of transfered data in our code
For example if you transfer Date, some of the data are correct but some is not in correct format, neverthless that you used Char field to store it for example.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only