Thank you Bob, I have figured out my problem and am now on to
the next task!
Thanx!
>>I have a small Foxpro table (because this is a test) that has the following fields:
>>
>>C(12), C(10), C(2), C(15), C(2), C(4), C(15), C(6), C(2), C(4), C(1)
>>
>>And on the SQL Server (6.5 Side) I have the same field names
>>as well as the same types (ALl Character, all same Size)
>>
>>I export out of Foxpro to a SDF File like this:
>>
>>> COPY TO Export TYPE SDF
>>
>>This gives me a nice text file. I then run BCP with the following command line:
>>
>>> bcp SQLFOXUK..Conthist_bcp in Export.txt -Usa -Ptifcbufnt01 - Stifcbufnt01
>>
>>Okay... Now it asks me the info for the format file, so I bomb through that since the 2 tables' fields are the same lengths etc...
>>
>>The data gets in, but on the 2nd record it starts moving over 1 character on through the file.. Can anyone tell me what I am missing?? I tried the /r\r Option in BCP and that causes more problems...
>>
>>Thanx!
>
>Bob,
> Here's a sample fmt file I use to bcp data from a text file created by doing a COPY SDF out of VFP. Check to see if your format file looks the same. I sure you know that you can edit the fmt files and call them from the command line when you run bcp: bcp SQLFOXUK..Conthist_bcp in Export.txt /f.... HTH
>
>Bob
>
>6.0
>20
>1 SQLCHAR 0 16 "" 1 part
>2 SQLCHAR 0 30 "" 2 partdesc
>3 SQLCHAR 0 2 "" 3 inprev
>4 SQLCHAR 0 2 "" 4 inpuom
>5 SQLCHAR 0 2 "" 5 insuom
>6 SQLCHAR 0 12 "" 6 inconv
>7 SQLCHAR 0 3 "" 7 inbcod
>8 SQLCHAR 0 5 "" 8 inccod
>9 SQLCHAR 0 3 "" 9 inpcod
>10 SQLCHAR 0 2 "" 10 inscod
>11 SQLCHAR 0 1 "" 11 ecrord
>12 SQLCHAR 0 20 "" 12 inlqcst
>13 SQLCHAR 0 10 "" 13 inecon
>14 SQLCHAR 0 14 "" 14 innqoh
>15 SQLCHAR 0 14 "" 15 innnqh
>16 SQLCHAR 0 1 "" 16 insrlf
>17 SQLCHAR 0 2 "" 17 inabcc
>18 SQLCHAR 0 6 "" 18 infldt
>19 SQLCHAR 0 6 "" 19 incomcd
>20 SQLCHAR 0 2 "\r\n" 20 indrsz
Previous
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