Thanks Grant. Meant to get back to this but have been swamped

It seems Im going to have to get my hands dirty with XQuery to get what I want which isnt a bad thing.

Thanks for pointing me in the right direction

Another alternative i found was that you can open up individual files

and then export those to tables. This will mimize the size of the temp file that gets created. It isnt really ideal as it wil always created the temp file on the c:\ drive