Skipping header row while doing bulk inset

• Shreenath

  Newbie

  Points: 1

  More actions

  November 12, 2004 at 1:10 pm

  #87037

  SQL server

  I have a data file with first row as header data and from second row onwards actual data.The column delimiter is '|' and row delimiter '\n' . When i do a bulk insert into SQL table from a flat file,the header record/row in the file should be omitted.The header record does not have delimiters.

  pls provide a solution for this

• Adam Machanic

  SSCoach

  Points: 15370

  More actions

  November 13, 2004 at 11:25 pm

  #530036

  BULK INSERT YourTable FROM 'YourFile' WITH (FIRSTROW=2, FIELDTERMINATOR='|')

  --
  Adam Machanic
  whoisactive