[AccessD] Access 2002 Export to XML using DTD's

MartyConnelly martyconnelly at shaw.ca
Mon Oct 31 12:32:06 CST 2005


A DTD only validates it doesn't transform,
You could use XMLSPY to convert your DTD to an XML Schema
Then use that to produce an XSLT (XSL file) to transform output from the 
XMLDom
This last step is an unknown to me in the product otherwise you will 
have to produce your own XSLT file
no mean feat, if not fully familiar with XSLT. I know you can create 
classes from schemas but only Java and C##.
What you are looking for is a schema mapping method.


You can get a 30 day trial of full edition or there is a limited home 
edition (need license key)

http://www.altova.com/download_components.html


Jim DeMarco wrote:

>I don't believe Access (any version) will use the DTD to determine how to output data.  The DTD is used to ensure that an XML file conforms to the spec detailed in the DTD.  You have to create the file yourself based on the DTD AFAIK.
>
>Jim DeMarco
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Greg Smith
>Sent: Monday, October 31, 2005 11:27 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Access 2002 Export to XML using DTD's
>
>
>Hi everyone!
>
>I know this is a shot in the dark, but I need to export data from an
>Access 2002 database to XML using a provided DTD (Document Type
>Definition).
>
>I need to be able to tell Access that it needs to use the DTD to provide
>the proper formatting for the XML document.
>
>Has anyone tried this before?  Or does anyone know of any good resources I
>can use to help figure it out?
>
>This is not a one-time deal either...once I get it set up, it will be a
>daily event.
>
>Thanks in advance!!
>
>Greg Smith
>gregsmith @ Starband.net
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list