How can I read a XML data file into a System.Data.Dataset variable type ? Can I use a readxml function ? My aim is to read an XML file into a Dataset or Datatable , and should be able to access the values by referring column_name like in a database table. Thanks in advance.

Check this [image] Xml File Comparison Help xmlToDt.xaml (6.1 KB)

Hello @vvaidya , I am experiencing some difficulties with my xml file. It shows a long row full of text but then in dt is is only two-words/two-columns only result. Could you help me out and send me some .xaml which could solve my problem with this particular xml file? Thank you so much in advanc…

Looks the multiple tables are being created since the Nodes are not consistent. Try ds.Tables.Count.ToString to check # of tables If you want to write all the tables to Excel, you can do below (multiple sheets) [image]

Reading xml file into dataset/datatable

Help

vvaidya (Vinay Vaidya) September 11, 2017, 1:34am 2

Check this

Topic		Replies	Views
XML_2_Dataset Help	1	1891	September 11, 2017
Import XML to Excel Help excel , activities	10	14953	July 4, 2018
XMLドキュメントをデータテーブルに落とす方法フォーラム	7	5325	July 25, 2019
Extract XML dataset into datatable Academy Feedback xml	2	4210	June 1, 2020
Xml to Datatable Studio	0	1018	April 22, 2020

Reading xml file into dataset/datatable

Related topics