Exporting XML, editing to conform with existing schema

Discussion in 'XML' started by Christopher M., Jan 2, 2008.

  1. I'm exporting XML from Access. There is an option to not export key and
    index information to a schema (XSD) file, but there's no option for the XML

    What I've been doing is using editors like AttEdit and XMLSpy to edit the
    XML by removing the keys so it conforms to an existing schema.

    I'm having a problem though. I have a bunch of child elements, and I'm
    trying to modify some elements of these child elements, but it seems that I
    can only modify one child's child at a time.

    It seems like the only solution is to write some code to modify all of the
    child elements or use Altova Mapforce. Or I guess I could try to modify my
    tables in Access to eliminate the keys and use other fields instead, and use
    where statements and cross joins instead of inner joins. Any ideas?

    W. Pooh (AKA Winnie P.)
    Christopher M., Jan 2, 2008
    1. Advertisements

  2. Write an XSLT stylesheet which strips out the unwanted info?
    Joseph Kesselman, Jan 3, 2008
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.