Ignore header in BCP text file import

• MLP

  Mr or Mrs. 500

  Points: 542

  More actions

  December 8, 2009 at 9:05 am

  #140593

  Hi,

  I need to import data from a pipe delimitted text file to a table. I'm using bcp to do the same.

  The input file contains header, data record and footer.

  header and footer contains 12 columns, where as data record contains 15 columns.

  I'm using -F option to ignore the header, but it is ignoring header and a data record as well.

  I have gone through the posting where they are suggesting a workaround of :

  1. Import each row to a column in a temporary table

  2. delete the header and footer from the table

  3. export the data in table to a text file

  4. Import the data in text file to destination table.

  Is there any other workaround apart this ?

  Thanks

  MLP