Create XML file from Access using predefined schema

[Guest]

Hello;

I work for a laboratory. We have lab data in Access 2003. The state has
required we supply them with this lab data in xml files. They have given us
the schema they want used to format the data.

I see in Access how to export data to an xml file. I also see how to have
Access create a schema file for that data. But it doesn't look like the data
in the state's schema.

How do I create an xml file using a pre defined schema?
Is there an article or help somewhere for me to look at?

Thank you very much for your help.

Bob Wardlow

 

[Guest]

I'll be interested in what other folk may bring to the table on this one.

I'm guessing that converting one xml file to a differing xml file is going
to be a uniquely defined process. That you are going to have to demarc your
data and how it's layout differs from their's - - and create a conversion
process.

What you might do is see if you can find out what brand of database they are
using....as this is probably the source of their xml. Then possibly you
could import from Access into X (Oracle?, DB2?...)...and then do the xml
conversion....of course that means you buy another database just for this
purpose....

 

[John Marshall, MVP]

You can use XML stylesheet transformations XSLT http://www.w3.org/TR/xslt to
convert between different XML stylesheets.

On the Export option, Is a More Option button so that you can choose a
different XSD. You will have to create this stylesheet to match what the
other system expects. Best starting point is to let Access create the style
sheet and then compare it with what you need to send.

John... Visio MVP

 

[Guest]

Thank you for your help. I will follow the link and look into stylesheet
transformations.