CODEWITHSUNDEEP
xmlms-accessvba
Lluis Martinez
Lluis Martinez

Reputation: 1973

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 task ?

Upvotes: 1

Views: 3284

Answers (3)

hgulyan
hgulyan

Reputation: 8239

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

Upvotes: 1

iDevlop
iDevlop

Reputation: 25252

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.

Upvotes: 0

David-W-Fenton
David-W-Fenton

Reputation: 23067

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.

Upvotes: 1

Related Questions