if you want to import xml from physical xml file into dataset than you can use this code snippet: Dim dsPubs As New DataSet() dsPubs.ReadXml(Filepath) thanks Please mark as answer if it help

hi.. if you get problem to get the data from excel file just follow this links its have result of conversion both .xls ans .xlsx conversion .. http://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html

You can import Excel in a DataSet and then use DataSet to export to Xml. OR you can also read Excel one by one and then create XML file and add data to it.

Answers

importing excel to xml file in c#

Sunil Goud

14y

5.5k

1 .NET Performance Tips

importing excel file

importing excel to xml file in c#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)