updating sql table from text file

• Horacio Merlo

  Newbie

  Points: 7

  More actions

  June 9, 2006 at 1:28 pm

  #171089

  Hi,can anyone help me?

  I need to update a SQL table reading a text file. I'm using Streamreader in vb.net , I split the string in it`s components but I don't know how to pass this splitted string as parameters to match with the columns of the table.

  Must be an update, in other case i've used BULK INSERT to insert files but in this case I can't

  example:

  txtfile(or CSV)

  "25786",""john","Myers",Glucose","130","Checked"

  Table

  Id       Name     LastName     determination   Value    Notes

  Thank you in advance!!!

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  June 9, 2006 at 1:37 pm

  #642904

  Bulk Insert it into a different table (typically called a "staging" table).

  Once the data is in the staging table, run an UPDATE joining the 2 tables on the unique key column(s).