export access table data to XML file using especific .xsd file

[amber capriles]

I export my table to XML using the export form from access but doesnt look like it should because is looks different from the .xsd file especificatins I must follow. How do I tell access to use this especific .xsd file when exporting my data to the XML file??

[NeoPa]

I couldn't see a way Amber.

It seems that it wants to export what you have and it tells you the XSD format. It even allows you to save it as part of the process.

I can't see your data and you don't really tell us anything to go on but I would suggest exporting it and comparing the CSD file produced with the one you're expected to match. When you see where they differ you should be able to create a query that matches the required XSD. If you export that then it may turn out to be in the correct format.

[amber capriles]

Hi, thanks for your answer... this export module within access really doesnt allow you to choose the xsd file you want...it generates one with the xml generated. My problem is I must have my xml looking ecxatly as government wants. how can I mofify this xml generated by this module after it has being created? I'm using one query only with all the data I need. How can I send you the xsd file and the query for you to see how you can help me? Please?????

[NeoPa]

Hi Amber.

I can't promise I even can help you, but if you can create a ZIP file including a cut-down version of your database with only the relevant tables and queries included and add to that the two XSD files then attach it to your next post I will look and see if there's anything I can do to see what's what and possibly end up with some advice for you. I'm no XML expert but I understand the basic concept so I'll see what I can find out.

NB. It's very important that you follow the instructions above very carefully and accurately. If any parts are missing then I won't even be able to look into it for you.