cfml

BCPChallenge.zip

I don't necessary know BCP but looking at  this definition for a fmt file
<https://learn.microsoft.com/en-us/openspecs/sql_data_portability/ms-bcp/98bbb35b-ced9-4fd4-88fc-3476f8b9917e>
that the ID="" is required for each field  you have maybe your fmt is a little off.

oddly, the format file was generated using a bcp command that builds the file by looking at the table

I think that is just used as a reference for the COLUMN - map X field in the text file to Y column in the database