XML Schema?

[DJV]

Hi! I am new to access, and am having trouble getting a correct export of XML out of an access database. I am not sure if it is a schema setup or something else. Any help would be GREATLY appreciated.

I have attached a file that shows the format that is coming from access (Bad Format) and the format I am needing (Correct Format). Any ideas?

 

[spikepl]

It is possible that something can be made out of the XML Access spits out, with transformations using XSLT. Unfortunately I don't know much about it. If I were stuck with your problem, I would look into writing the XML file myself.

The easy and dumb method is simply to output the information as required, by collecting it form queries and tables and writing it to file line by line.

The more complex, but in the long run more maintainable method, is to write the XML document yourself using the document object model. Google these terms:

XML DOM
write XML from VBA

If you have no clue about the above, then I would suggest that you in round one attempt to read your XML document into your database. This would familiarize you with the DOM, so that you know the terminology, and how to ineteract with the DOM. Afterwards you can code the creation of the XML document.

For checking/manipulating XML file, I found the "XML notepad" useful. It is a free XML editor you can download.