Results 1 to 2 of 2
  1. #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 ( 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.


  2. #2
    WS Lounge VIP
    Join Date
    Jun 2010
    Thanked 1,421 Times in 1,232 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