Importing Selected Columns from CSV to SQL 2008

• NoviceJatt

  SSCommitted

  Points: 1671

  More actions

  July 2, 2010 at 1:14 pm

  #237288

  Hi

  I'm new to Database. I have a CSV file with 20-25 columns and want to import only selected columns from this file into my table. Say I have columns like 1,2,3,4,5,6,7,8,9,. How do I import only columns 1,3,5,6. Can you guys give me any Idsea to Do that.

  Thanks

• Greg Snidow

  SSCoach

  Points: 16108

  More actions

  July 7, 2010 at 6:59 pm

  #1189943

  Novicejatt, again, this is a 2000 forum, and it seems like maybe you have 2008? Anyhow, as far as the one time uploads are concerned, I personally find OPENROWSET the easiest method for the Excel files, but that is just me. You can find out all about in BOL.

  Greg
  _________________________________________________________________________________________________
  The glass is at one half capacity: nothing more, nothing less.