Create XML from Access

We need to generate an XML using Access, is there any Visual Basic objects or functions that can help with the t开发者_开发问答ask ?

Have you tried Application.ExportXML? If you type "exportxml" into the help in the VBE, it will get you ExportXML method as the first choice.

Try using XmlDocument type.

http://www.functionx.com/vbnet/xml/Lesson02.htm

There's also Chilkat XML ActiveX.

https://www.chilkatsoft.com/chilkatxml.asp

https://www.chilkatsoft.com/refdoc/xChilkatXmlRef.html

I found it much easier to build my own functions. You can find the 3 functions here.
The basic idea is to build a recorset (query), loop through it to build your string. See the comments. The blog is in French but the code comments are in English.