Is there a way to create a .xml file from a form

[mpaulbattle]

When we install our application on our clients computers we have to create a configuration file that points it to their server. Currently the information we use to create the file is stored in our access db and we have one generic file that we update each time. I was hoping i can build a template and pull in the fields i need and then save it as a xml file.

DoCmd.OutputTo acOutputForm, "tblConfiguration", _
 acFormatXML, "configuration.xml", True

this works but it doesn't place the other text in it. It only pulls the fields from the form. (thinking this maybe because the comments are commented out)

I also have multiple text boxes too since the template is 5,100 characters long.

is what i asking even possible?

 

[Ranman256]

docmd.Transferspreadsheet.....