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!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement