hey and I know, “why the F***K would anyone want to use excel to drive an application.”
anyway I have imported a very simple xml file.
it all spans within the talbe structure.
The issue is when I come to validate or export it errors with “*denormalised data”
excel 2007
here is the xml structure.
<?xml version=“1.0” encoding=“UTF-8” standalone=“yes”?>
<results xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>
<sizeOfMarket>
<data>
<date></date>
<current></current>
<target></target>
<benchmark></benchmark>
<market></market>
</data>
</sizeOfMarket>
<volume>
<data>
<date></date>
<current></current>
<target></target>
<benchmark></benchmark>
</data>
</volume>
</results>
any light to share would be very much appriciated.