How to terminate CSV File data into XML in BCP Format

asked 2015-05-11 13:09:17 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Column Name Below

Column1,Column2,Column3,Column4,Column5,Column6

Data Below in CSV Format

Data1,Data2,Data3,Data4,Data5,Data6

Data1,"Data2 Data2",Data3,Data4,Data5,Data6

Data1,"Data2 Data2","Data3 Data3",Data4,Data5,Data6

Data1,"Data2 Data2","Data3 Data3","Data4 Data4",Data5,Data6

Data1,Data2,Data3,Data4,Data5,Data6

I want to convert this CSV format file data into XML and then It will help me to store data into ds(object of dataset) to database.

Any Help....

edit retag flag offensive close merge delete