Reading and converting to csv from XML (large data) problem.

Question

User177399542 posted

Hi 
      I have xml file having thousands of record and I want it to convert into CSV. I have implemented code to convert xml to csv in my previous projects(using Dataset.ReadXML) but it breaks as now XML file has thousands of records. Now I tried to convert using XmlReader but csv file shows me error as csv has limited rows. My questions are: 

1. Any good tutorial/Code/Idea about how to convert large XML files to CSV.  
2. How to pass XML records into multiple excel spreadsheets when data exceeds it max limit of rows?

Thanks

Answer 1

User477186420 posted

Check below link it may help you

http://stackoverflow.com/questions/3069661/convert-csv-file-to-xml

let me know in case of any query

Answer 2

User177399542 posted

Dear you have understood question completely wrong.  My question is regarding converting XML to CSV.
 

Answer 3

User477186420 posted

Check below link it may help you

http://forums.asp.net/t/1097714.aspx

http://www.csvreader.com/code/cs/xml_to_csv.php

let me know if any query