By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

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

P: 2
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??
2 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,419
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.
2 Weeks Ago #2

P: 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?????
2 Weeks Ago #3

NeoPa
Expert Mod 15k+
P: 31,419
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.
2 Weeks Ago #4

Post your reply

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