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!