Importing XML containing Complex Elements
I am attempting to manipulate XML with Excel and am having a problem. The
XML contains a complex element (an element with subelements). When the import executes, Excel treats the element as a single list, not a series of lists. And when I try to export it back out I receive the following messages: Map is not exportable because it contains the following: Denormalized data; A mapped element's relationship with other elements cannot be preserved. The XML file has an underlying XSD defining the complex element. Sample XML with complex elements: <Parents <Parent <Name</Name <DOB</DOB <Children <Child <Name</Name <DOB</DOB </Child </Children </Parent </Parents Can someone point me to some doco on how to handle complex xml elements? |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com