CSV file Import

• • Reply

  13 years ago

  by rajchekar

  rajchekar

  , India

  Joined 15 years ago

  Dear Developers,

                             I'm importing CSV  file to sql DB using ASP.  It works fine. But ,If a Cell contain a value like   john,inc  .If  a value like this it CSV take it as two values as john  and  inc  

  But i want in a single value as john,inc  .. How can i do tat

  Thanks in Regards,

  Raju

  Report abuse
• • Reply

  13 years ago

  by mmharinath

  M M Harinath

  Chennai, India

  Joined 15 years ago

  Hi,

  CSV means comma seperated value. Each cell value in CSV file is identified by comma. So, first replace comma with special character like tilt (~) in CSV and export CSV file data to sql server. Execute Update query a to replace tilt with comma in query analyzer

   

  Report abuse