applying schema to xml file

[renee2016]

I am new to xml. I currently have my data in ms access 2007 table as well as in mysql database. I need to export my data into a xml file but must be in the format specified in the XSD. How can I export my data from either ms access 2007 or mysql database so that it will be in the correct format?

 

[NickieP]

If there is just one XSD you can use one of the following to create the xml: Excel/Access/Infopath/Word , it does most of the work fo you.
Look up help in Access or Excel, there is a wizard I think.