BULK INSERT

• Beginner2012

  SSC-Addicted

  Points: 427

  More actions

  July 10, 2012 at 9:11 am

  #259189

  Hello,

  I'm using BULK INSERT to laod a comma delimited file into a SQL table. I only need a number of columns and want to ignore the rest.

  Any clues how to do that ?

  Thank you

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  July 10, 2012 at 3:07 pm

  #1511230

  BULK INSERT supports the use of a format file. See the FORMATFILE option: BULK INSERT

  Depending on what you meant:

  Using a Format File to Skip a Data Field

  or

  Using a Format File to Skip a Table Column

  edit: updated links to point to SQL 2005 docs

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Beginner2012

  SSC-Addicted

  Points: 427

  More actions

  July 16, 2012 at 12:39 pm

  #1513254

  Thank you !!!!!!!!!!!!!!!

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  July 16, 2012 at 12:55 pm

  #1513259

  You're welcome 🙂

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato