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.