Hello to everyone,
I am using Access 2003 at work (don't ask why!!) and have a problem with exporting to xml file. I have been given a xsd file as a schema for a required data set to give to another department. I import the xsd file to my database (as External Data) and about 10 tables are created. As I see it, I have to insert my records every time, create a query with the required fields and export them to xml file. However, I can't seem to understand how the epxorted xml file is supposed to obey to the structure of the xsd file. In the export process window, I go to More Options and see that the options only regard exporting to separate files (xml, xsd and xsl) and nothing about exporting to xml file using predefined xsd file.
The question is: How can I export to xml file with a predefined xsd file?