Thanks Makeitso, much appreciated.
the xml string is fairly large but i dont need everything in it. I need the columns below but if you give a couple of examples i can complete the code -
"[Picture], [Inspector_ID], [Inspector], [Store_details], [Region], [Time], [LastName], [UserName]...