Ritu

Ritu

  • 1.4k
  • 347
  • 42.8k

Insert comma deliminated data into sql server

Oct 13 2021 12:41 PM

I have xml file with below data. There is no xml tags and headers but file saved like (abc.xml)

1,"00277S-1","PO-003988"
2,"00119E","PO-003988"
3,"00277E-1","PO-003988"
4,"00700L","PO-003988"
5,"06900E","PO-003988"
6,"06901K","PO-003988"
7,"06901T","PO-003988"
8,"06901R","PO-003988"
9,"06901Y","PO-003988"
10,"01119C","PO-003988"

 

I want to read this file and get this data into sql table using c#. How this can be done.

Thanks


Answers (3)