That shouldn't be a problem, but I'm not sure if your format file is correct.
Here's one example that I use, it might help you out.
<?xml version="1.0"?>
<BCPFORMAT
xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="0" xsi:type="CharTerm" TERMINATOR='"'
MAX_LENGTH="1" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR='","'
MAX_LENGTH="10" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR='","'
MAX_LENGTH="3" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="3" xsi:type="CharTerm" TERMINATOR='","'
MAX_LENGTH="1" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="4" xsi:type="CharTerm" TERMINATOR='",'
MAX_LENGTH="1" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="5" xsi:type="CharTerm" TERMINATOR=','
MAX_LENGTH="9" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="6" xsi:type="CharTerm" TERMINATOR=','
MAX_LENGTH="9" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="7" xsi:type="CharTerm" TERMINATOR=',"'
MAX_LENGTH="9" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="8" xsi:type="CharTerm" TERMINATOR='",'
MAX_LENGTH="26" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="9" xsi:type="CharTerm" TERMINATOR=','
MAX_LENGTH="5" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="10" xsi:type="CharTerm" TERMINATOR=',"'
MAX_LENGTH="5" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="11" xsi:type="CharTerm" TERMINATOR='","'
MAX_LENGTH="4" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="12" xsi:type="CharTerm" TERMINATOR='",'
MAX_LENGTH="8" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="13" xsi:type="CharTerm" TERMINATOR="\r"
MAX_LENGTH="5" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="DAT_EXCHANGE" xsi:type="SQLCHAR" LENGTH="10"/>
<COLUMN SOURCE="2" NAME="COD_FCC" xsi:type="SQLCHAR" LENGTH="3"/>
<COLUMN SOURCE="3" NAME="FLG_FCCB3" xsi:type="SQLCHAR" LENGTH="1"/>
<COLUMN SOURCE="4" NAME="FLG_QUOTATION" xsi:type="SQLCHAR" LENGTH="1"/>
<COLUMN SOURCE="5" NAME="FIXRATE" xsi:type="SQLDECIMAL" PRECISION="9" SCALE="5"/>
<COLUMN SOURCE="6" NAME="BIDRATE" xsi:type="SQLDECIMAL" PRECISION="9" SCALE="5"/>
<COLUMN SOURCE="7" NAME="OFFERRATE" xsi:type="SQLDECIMAL" PRECISION="9" SCALE="5"/>
<COLUMN SOURCE="9" NAME="ENT_LASTMOD" xsi:type="SQLDECIMAL" PRECISION="4" SCALE="0"/>
<COLUMN SOURCE="10" NAME="BRN_LASTMOD" xsi:type="SQLDECIMAL" PRECISION="4" SCALE="0"/>
<COLUMN SOURCE="11" NAME="LASTMODTRM" xsi:type="SQLCHAR" LENGTH="4"/>
<COLUMN SOURCE="12" NAME="LASTMODUSER" xsi:type="SQLCHAR" LENGTH="8"/>
</ROW>
</BCPFORMAT>