krishna prasad

krishna prasad

  • NA
  • 814
  • 181.8k

Commas in csv file added database

Jan 26 2009 2:00 PM
Hai all.........

I have just added a csv file into my table in sql server....

The problem is all the values are encoded  within quotes...

for Ex:
"1"  "195.32.45.1"   "124.25.35" "tcp"
somethin like...It is difficult for me to use the datas in my code...
I want to remove the double quotes..I cant do it manually as i have a large dataset...

Help me please..


Answers (1)