Create XML from Access

Question

Hi,

We need to generate an XML using Access, is there any Visual Basic objects or functions that can help with the task ?

Thanks in advance

Answer 1

Try using XmlDocument type.

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

There's also Chilkat XML ActiveX.

http://www.example-code.com/vb/xml_format.asp

Answer 2

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.