1
Answer

Commas in csv file added database

Ask a question
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)