Export Query to XML File

[LadyDi]

I am having difficulty exporting a query I have to an xml file. I am using the docmd.OutputTo command, and I keep getting an error message that reads "Microsoft Office Access was unable to export the data". Is there a way to export the query as an xml file? I need the file to be xml, so that I can link it to a pdf file and then send it to my technicians. Do you have any suggestions?

 

[GohDiamond]

Did you try something like:

docmd.OutputTo acOutputTable,"MYFILENAME",acFormatXML,"YOUROUTPUTFILE.xml"

Cheers!
Goh