Create XML from Access

Question

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

What exactly do you need? An xml file or just a string? What's the purpose of generating xml? — hgulyan
– hgulyan, Commented Mar 30, 2010 at 9:55

Gord Thompson · Accepted Answer · 2014-09-21 11:37:31Z

1

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.

edited Sep 21, 2014 at 11:37

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

answered Apr 2, 2010 at 17:13

David-W-Fenton

23.2k4 gold badges48 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hgulyan · Accepted Answer · 2018-12-17 09:08:50Z

1

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

edited Dec 17, 2018 at 9:08

answered Mar 30, 2010 at 10:01

hgulyan

8,2799 gold badges53 silver badges77 bronze badges

1 Comment

hgulyan Over a year ago

@HackSlash Thanks, updated to original documentation

Patrick Honorez · Accepted Answer · 2014-09-21 12:49:20Z

0

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.

answered Sep 21, 2014 at 12:49

Patrick Honorez

25.4k12 gold badges97 silver badges163 bronze badges

Collectives™ on Stack Overflow

Create XML from Access

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related