Question XML Schema

[Les Isaacs]

Hello All

How do I output data from an access2010 accdb as an xml file that complies with a pre-defined schema?

Our access2010 application is used to process payrolls - calculating pay, tax, national insurance and pension deductions. The government is introducing a new requirement for payroll data to be submitted to them, and the data must be submitted as an xml file that complies with a very specific schema: I have attached an example of the file that must be generated.

Hope someone can help.
Thanks in advance
Les

 

[shazywie71]

are you aware of xml tools like [FONT=&quot].liquid-technologies.com/xml-editor.aspx[/FONT]? That will let you validate your xml file against the schema, so you would load the schema you mentioned into its library and then simply validate your xml file against it.

 

[Les Isaacs]

Hi 'shazywie71'

Many thanks for your reply: I was beginning to give up hope!!

In fact the government has provided a 'test service' to validate xml files against their schema: the problem I have is how to 'tell' access about the schema - i.e. how to specify the precise structure of the required xml file in a way that access can use. I just can't seem to see how to do that.

Any ideas?

Thanks again
Les