Thanks for getting back. I added a duff column and modified my format file slightly with guidance from http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/10/04/bcp-bulk-insert-format-file-escape-a-quote-more-to-the-point-loading-quoted-csv.aspx
My format file now looks like this:
10.0
7
1SQLCHAR01""1DuffColumn""
2SQLCHAR050"\",\""2FromIP""
3SQLCHAR050"\",\""3ToIP""
4SQLBIGINT019"\",\""4BeginNum""
5SQLBIGINT019"\",\""5EndNum""
6SQLCHAR050"\",\""6CountryCode""
7SQLCHAR0250"\""7CountryName""
The only issue I have left...