BCP command with a format file to skip a header row issue.

Copper Contributor

While using BCP command with format file to insert a large file i.e. 7GB in size export to database table without a header row then we unable to insert the first row of data.

I used -F1 and -F2 both in PowerShell command for skipping the header only but both are not working.

The main problem is my header contains only 3 columns and the data is about 13 columns that's why the first record is included with a header.

My sample data is as follows : 





In this sample data, the record that is in bold is not inserted in the database.


Can anyone please suggest any solution?


0 Replies