Export data from access to xml

[777bonzai]

I have an access db and the db has two tables "parent" and "parent_cas e". I would like to export data from these two tables into xml. I did the export and unchecked opition "include primary key or index" in the schema tab, but somehow the primary id is repeated in the patient_case part, how can I get rid of this? In addition, with the xml data file, instead of saying "dataroot" at the top, I would like to rename it something else like "qic_parent ". the follwoing is the xml data file:

<?xml version="1.0" encoding="UTF-8" ?>
- <dataroot xmlns:od="urn:s chemas-microsoft-com:officedata" xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance" xsi:noNamespace SchemaLocation= "parent.xsd " generated="2012-01-11T08:16:34">
- <parent>
<parent_id>1111 1</parent_id>
<address>999 abc st</address>
<phone>70399999 99</phone>
- <parent_case>
<parent_id>1111 1</parent_id>
<lastname>Doe </lastname>
<firstname>John </firstname>
</parent_case>
</parent>
- <parent>
<parent_id>2222 2</parent_id>
<address>888 abc st</address>
<phone>70388888 88</phone>
- <parent_case>
<parent_id>2222 2</parent_id>
<lastname>Jan e</lastname>
<firstname>Mary </firstname>
</parent_case>
</parent>
</dataroot>

thanks,
Bonzai

[777bonzai]

basically, how can I convert a flat file xml into a hierarchical xml.
thanks,
bonzai