Patrick,
>I attempted to use the XMLAdapter. This data is based on the ACORD Life2 standard and I am using their XSD file. When I attempt to load the xml file without the schema it loads but the Tables collection has 0 tables in it.
In some cases, you can read a complex XML stucture into XMLAdapter by defining the XMLField and/or XMLTable objects via XPath expressions (new in VFP9). It involves storing an XPath expression into the XMLName property of the object (stored as Unicode, so you have to use STRCONV when setting the property), and setting the object's XMLNameIsXPath property to true.
I'm working on some samples for this right now for an upcoming conference session, but can't give you the exact steps quite yet. There are issues involving the exact timing of adding the manually-defined XMLTable and XMLField objects to the Tables and Fields collections. Hopefully I can give a better answer later, or perhaps Aleksey will jump in here with a few tips. :-)