>>>>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.

The table only has a bunch of char(10) fields, 2 integers, 1 numeric and 1 logical field. The logical field has all .F.'s. The SQL table that is created has a matching structure. Allowing nulls in the SQL table doesn't doesn't help. Anything else I can check?
TIA,
Viv