hierarchical xml, how to?

[giovi2002]

In order to get a more efficient xml file (with less data) I thought let's make a hierarchical. How can I make a hierarchical file and easily import it into access without a dtd or schema?

Table basicinfor
Name state

Johanna NY
Exis NY
Albert TX

The 'state' has recurring values and could be reflected more efficiently in a hierarchical order

<Basicinfo>
<State>NY
<Name>Johanna</Name>
<Name>Exis</Name
</State>
<State>TX
<Name>Albert</Name>
</State>
</Basicinfo>

But it doesn't work!

 

[JontyMC]

What are Johanna, Exis and Albert? 'Name' is not very descriptive. Are they places? I would do something like:

<Basicinfo>
  <State>
    <Name>NY</Name>
    <Place>Johanna</Place>
    <Place>Exis</Place>
  </State>
  <State>
    <Name>TX</Name>
    <Place>Albert</Place>
  </State>
</Basicinfo>

Jon

"I don't regret this, but I both rue and lament it.