Importing XML data into Excel

Hi there,

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.



Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Can you post the XML that does not work, and the XML that does work, for comparison purposes?

Another option would be to import the XML data to MS Access first, then export from Access to Excel.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.