I have a vb.net web app that exports data via SQL to 3 XML files. The first 2 XML files are logically arranged and contain data on different types of automobile engines and come from 1 table with 5 columns.
However, the 3rd XML file holds data on various engine parts, engine suppliers, and engine warehouses. The data comes from 6 different tables and about 25 different columns. Now I am faced with the task of trying to import this XML file back into my web app using bulk load. I started to create the XSD schemas for the bulk load and the XSDs for the first 2 XML files were fairly simple. But this 3rd XSD for the 3rd XML seems almost impossible! Looking at the XML file, there is really no way of telling where the data came from. I can kind of guess, but obviously the XML bulk loader can't do that.... Is there a way to get myself out of this mess? Thanks!
