Export to XML, no sub trees?? (Access 2007)

[Manthis]

Hi,
I have a simple Access database that I want to export as XML, but I'm not getting a correct export format, I'm getting this:

- <Entities>
<Ent_ID>6188</Ent_ID>
<Name>name1</Name>
<FirstName>firstname1</FirstName>
<LastName>lastname1</LastName>
- <Entities>
- <EntitiesAddresses>
<Address_ID>15488</Address_ID>
<Ent_ID>6188</Ent_ID>
<Address>address1</Address>
<City>city1</City>
<Country>country1</Country>
- </EntitiesAddresses>

but i want it whith subtrees like this:

- <Entities>
<Ent_ID>6188</Ent_ID>
<Name>name1</Name>
<FirstName>firstname1</FirstName>
<LastName>lastname1</LastName>
- <EntitiesAddresses>
<Address_ID>15488</Address_ID>
<Address>address1</Address>
<City>city1</City>
<Country>country1</Country>
- </EntitiesAddresses>
- <Entities>

Is there a way to change the export the way I want it? or do I have to find another app that can do it? if this is the case what apps do you recomend?

By the way all the table's relationships are configured correctly.

Thanks for the help!

ACC

 

[Manthis]

Within Visual Studio 2005 I found an excellent tool that can help me. Txs again.