We are using SQL 7 and I am using the BCP to take data out of MS SQL and tring to put new records into SQL. If I try to use BCP from a foxpro table "COPY TO c:\try.txt TYPE DELI" with the BCP command "BCP.EXE database..table in c:\try.txt -c -t , -Sipaddress -Uuser -Ppass" it gives me an error "String data, right truncation" but if I do it with the wizards it imports allright. Has anyone ran into this or is it something with the BCP?