One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
In my role as ZA, I look for such things as too-quick thread closures and incomplete (or wrongly accepted) comments. Helps make sure that your firewall rules are working as intended.I awarded you points as I recognised the data was not truely validated and your solution was perfectly valid, but did not meet my requirements.I hope this helps you understand the way I think and why I closed the question. long story short I have tables in Excel that I wish to convert to XML and... I can import the XML file to Excel and Excel finds the referenced Schema (happy days).
I can edit the XML file in Note Pad and when I press refresh the update info appears in Excel.On the Data menu, point to XML, and then click XML Map Properties to display .