Newbie in makin XML formula

[petko]

Hi, in my company we issue invoices from the central Access database, that has been working perfectly for 15 years. However now an XML format file is required after each invoice issue holding the issue details and sent to a central authority.
I'd like fix this from vba but I have no any experience in making such transformation.
Can anyone help with a comprehensive and basic description/example?

I appreciate your help in advance
petko

 

[theDBguy]

Hi. There must be a template (DTD) or a schema they gave you to follow, no?

 

[petko]

Actually they provided one, I attached a shut of it.
I can follow the logic but don't know how to creat such a file.
petko

 

[theDBguy]

Actually they provided one, I attached a shut of it.
I can follow the logic but don't know how to creat such a file.
petko

So, basically, you would just map your table structure to the XML schema. If they don't match, you will have to compensate (maybe with empty nodes). Then, you would just create the XML file while looping through your records and writing the data, with appropriate tags, to a file.

 

[Gasman]

This might help?

FreeVBCode code snippet: Create XML Using the MSXML Object Library

This is the snippet Create XML Using the MSXML Object Library on FreeVBCode. The FreeVBCode site provides free Visual Basic code, examples, snippets, and articles on a variety of other topics as well.

www.freevbcode.com

Edit: It might not. I tried adding the latest MSXML library and it still balked at creating some of the objects as undefined. Sorry.

 

[petko]

The question still stands how I can create the XML file from my data. Please specify a bit more.
Thanks!

 

[theDBguy]

The question still stands how I can create the XML file from my data. Please specify a bit more.
Thanks!

Hi. To be specific, we have to know your data structure. Can you share it with us? See if this article helps.

Working with XML files in VBA (VBA XML) - Analyst Cave

How to work with XML files in VBA (VBA XML). Learn how to use XPath and how to traverse the XML Dom with the MSXML2.DOMDocument object.

analystcave.com