BCP import and export, the column order is wrong, the imported data is misaligned ??? Please help prawn

内心狂热

I do this.
I first create an XML format file, then export the DAT data file, and then use the DAT with the XML file to import the same table name into another database, but the column order is different from the table in the source database.
It turned out that the imported data was misplaced.

What is going on>

我是杀人狂

Does the data file have a NULL value ..

内心狂热

No NULL value and no default value.

prajna

Output in queryout mode, specifying the order of the fields

内心狂热

But what if you don't know the fields beforehand ???

prajna

When you create a table, the fields in the two tables must be created in the same order.

内心狂热

What if the table is already built and the order is different?

内心狂热

like

我是杀人狂

Add a NULL field to correspond ~

prajna

New table-> Import data-> Delete old table-> Rename new table