><?xml version="1.0"?> ><TimeSlip xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> > <TimeStamp>20091111130758</TimeStamp> > <Category>CUSTOMER RACE</Category> > <Rnd>Q</Rnd> > <Bump /> > <Left> > <QualPos>0</QualPos> > <CarNumber>1</CarNumber> > <Name /> > <ClassName /> > <ClassIndex /> > <DialIn /> > <RT>.350</RT> > <ft60>2.453</ft60> > <ft330>6.712</ft330> > <ft660>10.200</ft660> > <mph660>70.73</mph660> > <ft1000>13.171</ft1000> > <mph1000 /> > <ft1320>15.659</ft1320> > <mph1320>90.47</mph1320> > <MOV /> > <Win /> > </Left> > >>the info in the XML file goes on and on from there.
< data_table > < row > < field >< /field > < field >< /field > < /row > < /data_table >This is illustrative, fields can be attributes instead of tags but general layout is that you need a root ( data_table the table IOW ), rows and fields. You can use XMLAdapter instead or MSXML2.DomDocument parsing. Another alternative would be to do some processing of the XML with StrExtract() and make it XMLToCursor() compatible in parts.