XML export

[Frank]

I must export a query as XML ... there is a .xsd file ... can anyone please
explain how I make the exported .xml match the .xsd file? ... can I somehow
"feed" the query "through" the .xsd file? ... or must I write code to create
the .xml file in the format specified in the .xsd? ... surely not! ... if I
use Access's raw functionality the header in the exported .xml file is
(obviously) not what the .xsd specifies ... thanks in advance ...

 

[Stefan Hoffmann]

hi Frank,

I must export a query as XML ... there is a .xsd file ... can anyone please
explain how I make the exported .xml match the .xsd file? ... can I somehow
"feed" the query "through" the .xsd file? ... or must I write code to create
the .xml file in the format specified in the .xsd? ... surely not! ... if I
use Access's raw functionality the header in the exported .xml file is
(obviously) not what the .xsd specifies ... thanks in advance ...

Using Access 2003 or higher, you can specify a XML transformation to
generate a XML file matching your schema (there is a Transform... button
in the XML export dialog). But you need to write that XSLT first.


mfG
--> stefan <--

 

[Frank]

Thanks for that ... am I able to do the transform using code?

 

[Stefan Hoffmann]

hi Frank,

Thanks for that ... am I able to do the transform using code?

What do you mean?

Imho you can use the XML export via tha Application object and specify a
XLST.
You can also use MSXML (set a reference to the MS XML library) to create
a XML document manually and craft it according to your schema.


mfG
--> stefan <--