Check out my response in this thread, it details how to parse xml with sql syntax.
http://www.vbforums.com/showthread.php?t=651476