2011-01-20, 03:52 #1
- Join Date
- Feb 2010
- Essex, UK
- Thanked 0 Times in 0 Posts
Using external schemas to publish from Access
Greetings. Having never tried to export XML from Access before, I am having problems. I have set up a number of relational tables, and I want to export them according to an externally published schema (http://www.dft.gov.uk/naptan/schema/2.4/NPTG.xsd if you are at all interested).
However, I only seem to be able to export one table at a time (plus any tables linked through the relationship), and then only to the Access schema - I cannot get it to reference the external schema at all. Even then, when I do it in parts and try and reunite them later, I discovered that certain fields such as CreationDateAndTime, which are attributes in the schema, are exported as elements in the XML. In fact, I spent so much time trying to manipulate it in an XML editor that I might just as well have created it by hand there!
So what am I doing wrong? Or do I have to write a transform for it, or program it up in VBA? Thanks.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2011-01-20, 04:23 #2
- Join Date
- Jun 2010
- Thanked 1,138 Times in 1,049 Posts
I don't think Access can use an external schema. Only did this once, on Access 2007 and the solution I found back then was to write VBA to output the data according to the external schema.