OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   anyone try putting xml into multiple tables in SQL

[ Lists Home | Date Index | Thread Index ]

This seems to be fairly complex...I am trying to update a contact database. Say it has two tables: Person and Organization. There is a many-to-many relationship between the 2 tables (because of the ridiculous complexity in our org.). Say my XML file has a person record and the organization he/she belongs to. How do I export this to SQL so that it updates all the tables- both people, org and the cross reference table?


Anyone experienced something vaguely similar to this before?






Neile Bermudes

Network Support Analyst

England & Wales Cricket Board

020 74321241



News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS