Hi. I'm a beginner with Excel 2003, and the XML Mapping abilities the program has. Currently, I have been able to export the xml with smaller projects, but I have run into a problem. If I have and XML document with the form of something like:
and in my Excel table I have two columns; one named "item description (English)" and the other named "item description (French)". I would like to have each of those columns associate with it's corresponding "description" tag in XML. However, in the XML source tree (data>XML>XML Source..., then add the XML file) it only displays 1 "Description" tag with the attribute "lang". How get the data to map properly so that both columns (English and French) get mapped to the same "dscription" tag while also knowing which "lang" attribute to include (ie, either "EN" or "FR")?
Any help would be much appreicated.
Thanks,
URL
Code:
<item>
...
<description lang="EN"></description>
<description lang="FR"></description>
...
</item>
and in my Excel table I have two columns; one named "item description (English)" and the other named "item description (French)". I would like to have each of those columns associate with it's corresponding "description" tag in XML. However, in the XML source tree (data>XML>XML Source..., then add the XML file) it only displays 1 "Description" tag with the attribute "lang". How get the data to map properly so that both columns (English and French) get mapped to the same "dscription" tag while also knowing which "lang" attribute to include (ie, either "EN" or "FR")?
Any help would be much appreicated.
Thanks,
URL