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.