Slowgeek » Forums » Technical Support
 
FAQ   •     •   Login  •   Challenge Search:

Can't get detailed .xml data into Excel

(1 post)

  1. kmcgator

    new member
    Joined: Feb '11
    Posts: 1

    I was able to easily export the summary level .csv data into Excel, but when I attempt to bring in the detailed .xml data (with all the split info, etc) into Excel I get a message that says "the specified xml source does not refer to a schema. Excel will create a schema based on the XML source data". This creates an .xml source tree on the right side of the Excel workbook with titles that look like what I am looking for, but it doesn't allow me to map any of those elements into the worksheet (when I try to drag and drop them, they don't appear on the worksheet).. can you walk me from the point where it brings up the .xml data in my browser to how I get it into Excel. I am a proficient Excel user, so I should be able to figure this out, but can't get it to work for some reason..

    Thanks!

    Kevin

    Posted 1 year ago #      

Reply

You must log in to post.

RSS feed for this topic