How do I map multiple XML elements in excel?

[Guest]

Hi, I'm trying to map a single XML element to multiple columns in 2003 Pro
Excel and I'm having a bit of trouble. I've mapped my XML schema to XML
Source... and I'm trying to map a child element to multiple cells.... My
schema looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<schema xmlns="http://www.w3.org/2001/XMLSchema">
<element name="Root">
<complexType>
<sequence>
<element name="Distribution" maxOccurs="unbounded">
<complexType>
<sequence>
<element name="town" type="positiveInteger" />
<element name="species" type="positiveInteger" />
</sequence>
</complexType>
</element>
</sequence>
</complexType>
</element>
</schema>



and I want to map species to a bunch of columns... however, I get the
message: This element is aleady mapped, an element cannot be mapped more than
once.

I read in the troubleshooting section you need to change the ancestor
element... but I'm not sure what to do. Can anyone help?

Thanks!

 

[Guest]

I'm sorry... here is the schema again...

?xml version="1.0" encoding="utf-8" ?
schema xmlns="http://www.w3.org/2001/XMLSchema"
element name="Root"
complexType
sequence
element name="Distribution" maxOccurs="unbounded"
complexType
sequence
element name="town" type="positiveInteger" /
element name="species" type="positiveInteger" /
/sequence
/complexType
/element
/sequence
/complexType
/element
/schema