We were not using a format file, rather we were just using the /c method of copying an entire string. We shall attempt to use a format file and see if that fixes things up... THANKS!!

>Here is a sample format and you might just be missing the last segment on the last field to identify the record termination... I missed it in the beginning also.
>
>I also have a somewhat small program that will create the necessary .FMT format file, .BAT file, and copy type sdf .TXT file for upload to SQL-Server. If interested, let me know...
>
>Here is a sample .FMT format.
>6.0
>7
>1 SQLCHAR 0 11 "" 1 TYPE
>2 SQLCHAR 0 11 "" 2 CATEGORY
>3 SQLCHAR 0 35 "" 3 NAME
>4 SQLCHAR 0 11 "" 4 CA_ODB
>5 SQLCHAR 0 11 "" 5 CA_FYSNAP
>6 SQLCHAR 0 11 "" 6 CA_EPIDAYS
>7 SQLCHAR 0 11 "\r\n" 7 CA_CAP
>
>I think you are just missing the \r\n to identify end of record.