make xml using ms access 2003 1

[OhioSteve]

Currently, I export data using the "transfer text" action in macros. I understand that you can do the same thing in vba with docmd.transfertext. Is there an easy way to get it to output xml instead of a text file?

 

[PHV]

Have a look at the Application.ExportXML method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[OhioSteve]

Thanks!