You can use STREXTRACT() function to pull data between the tags..

>next I tried West Wind Client Tools and remove the all the tags except for table1
>

><?xml version="1.0"?>
><table1>
>	<Detail_Collection>
>		<Detail PP="
>...
>...
>	</Detail_Collection>
></table1>
>

>
>and that works like a charm. So I was think of removing the offending tags programatically and running the xml through West Wind XML tools. I'm not very savy with XML, how would I correct the XMLAdapter issue (how is it that used, couldn't understand examples) or XMLTOCURSOR issue? The file is 1.5mb.