Results 1 to 2 of 2
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.
2011-01-20, 04:23 #2
- Join Date
- Jun 2010
- Thanked 1,225 Times in 1,110 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.