Hello,
I have 2 tables in Access (patient and accident). I want to export the data from the 2 tables to XML.
Access output the following XML code:
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="case.xsd" generated="2012-07-22T17:08:15">
<case>
<patientcode>00002</patientcode>
<patient>
<patientcode>00002</patientcode>
<age>53</age>
<gender>1</gender>
<asa>1</asa>
</patient>
</case>
<accident>
<patientcode>00002</patientcode>
<datetime>2002-09-06T00:00:00</datetime>
<cause>1</cause>
<trauma>1</trauma>
<type>3</type>
<typeComment>trug Fahrradhelm</typeComment>
</accident>
</dataroot>
XML from Access looks different, from the XML code from the client (see code below).
Is there any way to custom the output XML code? Is this possible with the XSD template or must i have write a VBA code the produce the custom XML code ?
<patientCode>00111</patientCode>
-<masterData>
-<patient>
<gender>1</gender>
<age>28</age>
</patient>
-<accident>
-<dateTime>
<date>2011-01-01</date>
<time>08:30:00</time>
</dateTime>
<cause>1</cause>
<type>1</type>
</accident>
with regards
Martin Bruinsma