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.
Stuart
