Export using a DTD - HELP!

[rmorrison]

Hi, I have a query showing current certificates and sites for active
clients in my database. I need to export this to an xml file using the
format described in a dtd. How do I do this?

Any assistance will be much appreciated.
r

 

[AnandaSim]

Hi, I have a query showing current certificates and sites for active
clients in my database. I need to export this to an xml file using the
format described in a dtd. How do I do this?

Any assistance will be much appreciated.
r

Perchance can you show us the DTD?

Ananda

 

[rmorrison]

Here it is:

<?xml version="1.0"?>
<!ELEMENT certificates (certificate+)>
<!ELEMENT certificate
(organisation,brandname?,contact?,certnum,initdate?,expirydate?,descript?,streetno?,suburb?,city?,state?,postcode?,country?,phone?,fax?,email?,sitelist?,standardlist?,anzsiccodelist?)>
<!ELEMENT organisation (#PCDATA)>
<!ELEMENT brandname (#PCDATA)>
<!ELEMENT certnum (#PCDATA)>
<!ELEMENT initdate (#PCDATA)>
<!ELEMENT expirydate (#PCDATA)>
<!ELEMENT descript (#PCDATA)>
<!ELEMENT streetno (#PCDATA)>
<!ELEMENT suburb (#PCDATA)>
<!ELEMENT city (#PCDATA)>
<!ELEMENT state (#PCDATA)>
<!ELEMENT postcode (#PCDATA)>
<!ELEMENT country (#PCDATA)>
<!ELEMENT contact (#PCDATA)>
<!ELEMENT phone (#PCDATA)>
<!ELEMENT fax (#PCDATA)>
<!ELEMENT email (#PCDATA)>
<!ELEMENT sitelist (site+)>
<!ELEMENT site (site_address,site_contact?,site_phone?,site_fax?)>
<!ELEMENT site_address (#PCDATA)>
<!ELEMENT site_contact (#PCDATA)>
<!ELEMENT site_phone (#PCDATA)>
<!ELEMENT site_fax (#PCDATA)>
<!ELEMENT standardlist (standard+)>
<!ELEMENT standard (#PCDATA)>
<!ELEMENT anzsiccodelist (anzsiccode+)>
<!ELEMENT anzsiccode (#PCDATA)>


I don't know how to get Access to export using this format.

Thanks in advance.