XML in Access

[zrazzaq]

Hi I have a file that in xml should look something like this

- <aim agencyid="2">
 - <payments agencyid="2">
   <payment filenumber="10571" reason="PU" amount="75.00" datepaid="01/06/2006" /> 
 </payments>
</aim>

now the issue I am having is that when I use the export function in Access it gives me a file like this:

- <Query2>
  <Aim_x0020_Agency>2</Aim_x0020_Agency> 
  <Payment_x0020_Agency_x0020_ID>1</Payment_x0020_Agency_x0020_ID> 
  <Payment_x0020_Filenumber>1745</Payment_x0020_Filenumber> 
  <Reason>PU</Reason> 
  <Amount>3073.27</Amount> 
  <datepaid>2003-01-16T00:00:00</datepaid> 
  </Query2>

Can anyone tell me how to format this file. Thanks
Z

 

[psemianonymous]

Use XLST. Seriously, go to the query designer and rename all your column headings so they match your desired output, and retype your data (e.g. Format([dtfield], "mmddyyyy")) as necessary. As for the remaining bits, hopefully you're ok with doing it all by hand? Or maybe then you'll be ready for XLST.

 

[psemianonymous]

XLST -> XSLT, and by that I mean

http://www.google.com/search?hl=en&q=xlst