Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2010
    Location
    Essex, UK
    Posts
    44
    Thanks
    4
    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.

    Stuart

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,400
    Thanks
    131
    Thanked 1,167 Times in 1,071 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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •