Using Bulk Insert

• info2boom

  Grasshopper

  Points: 11

  More actions

  November 18, 2008 at 10:32 am

  #73104

  Hi

  I am trying to insert data using bulk insert from a .csv file. But I am having problem in getting rid of double quotes in the flat file. The file format look like this:-

  "maria,http://avatar.candy.com/ksjd/d23s.htm,1234"

  "nicloe,http://avatar.candy.com/sdfjd/d3e3.htm,3434"

  "anna,http://avatar.candy.com/rtyry/ds34.htm,23463"

  I tried with formatfile but couldnot able to figure out how to remove quotes on each row/columns.

  Please anyone could be to able to give me some light on this

  thank you

• Jeff Moden

  SSC Guru

  Points: 1004366

  More actions

  November 18, 2008 at 9:56 pm

  #900294

  Starting reading here... all is explained in that post and additional clarifications are made further down.

  http://www.sqlservercentral.com/Forums/Topic165368-8-1.aspx#bm165996

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)