I need help. I only been using access for about 8 months. From looking at things on the internet, I think what I need to do to get my xml file to export from access 2007 with the file structure I need is to add element or append child nodes but I really don't know how to do that.

There are some tags that I need to add to my file so it would have the correct structure. How do I accomplish this? Thru adding elements or some other way? Right now I am exporting the file and doing it manually by find/replace but I need to automate the process so I can create a button that will export the file for me so other people in the company can do it and not just me.



I greatly appreciate any help I can get. I don't want to resort to pulling my hair out.

can you explain the bigger picture? what is the business issue you are trying to achieve?

The issue is when I export my data from access into xml it is not exporting in accordance with the schema/structure that I need.

for instance I am getting:



I need :



How do I add this other tags. Do I use elements/ child nodes? or do I use something else? I never used elements or nodes before, I am not a programmer.