If you can write some .net code (C#/VB). Then you can loop through the folder containing the XML files and use the dataset.ReadXml(filename) to get it to a dataset.

Then its...

That was a lightning fast reply. Thank You.

Below is the code I ended up with. Please let me know if you have other ideas.

SELECT A.tblname...