enclosing xml in reformated data tag

[smjones316]

Hello,

Using Access 2007 but I believe the database is saved in 2003 format.

Im trying to export an xml file...exporting is fairly easy but getting my data properly formatted on export seems quite the task. Each on of my data sets is enclosed in my table name ie <xmltable>'dataset'</xmltable>..which of course is the name of my data in my table. Instead of the table name I need these to be wrapped in <Package ID='1'>data set</Package>, where '1' is a tag counter. Below is an example of what Im exporting incorrectly


- <XMLTable>
<Status>Lisa Berez</Status>
<Description>AL34264974</Description>
</XMLTable>
- <XMLTable>
<Status>Larry Pranger</Status>
<Description>AL34296823</Description>
</XMLTable>
</dataroot>


The way I want it enclosed is:


- <Package ID='1'>
<Status>Lisa Berez</Status>
<Description>AL34264974</Description>
</Package>
- <Package ID='2'>
<Status>Larry Pranger</Status>
<Description>AL34296823</Description>
</Package>
</dataroot>

notice that I am trying to change the actual table name to a specified name that also has a counter tag with each package that would continue to increase with each additional dataset.

Any help is greatly appreciated.