How to load a table using BCP
I wrote a blog post showing some sample BCP commands, including how to create the format file, at https://www.sqlserverscience.com/tools/example-bcp-export-import-commands/

This command should create the format file that is essential for import via bcp:

bcp "dbo.Oranges" format nul -S "FRUIT\PEARS" -T -d "Fruit" -n -f "C:\some\path\Oranges.fmt" -x


dbo.Oranges is the table name.  FRUIT\PEARS is the SQL Server instance name.  Fruit is the database name.

If you're having trouble with the XML file, I would recommend using the native binary format generated by BCP  It ensures the export and import will work without any data loss, and is fully supported across various versions of SQL Server.