Information générale
Forum:
Microsoft SQL Server
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
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