1. Don't use anything but SQLCHAR when importing text files.2. Don't use anything but "" for coalation on non-character based columns.
Does the last line of your format file have a trailing CR/LF? Since it is complaining about the last field of the last line, I think this might be the problem. The last line should be terminated with a CR/LF, the file should not just end after the collation field.