I am having difficulties importing XML data into excel in one go.
There are around 25000 records and 30 columns, howver when I try to import the data in one go i get the below error:
no data was imported or only some of the data was imported
To overcome this i break the xml file into roughly half the size and import this into excel without any problems. Is there any way i can actually import all the xml data in one go as there will always be 25000 or less records and 30 columns.