Hello,

We are attempting to import an exported foxpro table into SQL 6.5, we are using the BCP program and the /c (text) import functionality. BUT, we are encountering errors because the BCP copy is failing to recognize the end of record terminator.

We have tried multiple methods of setting, and reading the terminator, and are certain that we have included a CHR(13)CHR(10) at the end of every record. BCP is still reporting record overflows, IE: failing to notice the terminator.

We also attempted explicit record terminators, IE: *, **-** etc, to no avail. (ALSO set BCP /r *, /r **-** appropriately), this failed to import aswell.

Any help would be greatly appreciated.
Keith