471,109 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,109 software developers and data experts.

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

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??
Jul 3 '19 #1
3 1143
32,348 Expert Mod 16PB
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.
Jul 4 '19 #2
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?????
Jul 4 '19 #3
32,348 Expert Mod 16PB
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.
Jul 4 '19 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by Venkat | last post: by
2 posts views Thread by OutdoorGuy | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.