Andy Dingley wrote:
> Zamdrist wrote:
>
> > I'm looking into SQLXMLBulkLoad Com object right now, looks like what
> > I'll need to use.
>
> Looks like a reasonable place to start.  Of course it might not give
> you the table structure you want, but consider loading into an ugly
> scratch table, then fixing that through the SQL you're familiar with.
>
> Some notes:

Thank you Andy, looks like some good advice.

All I really wanna do is grab the data and slam it into SQL Server,
work with the data from there, I don't want to do anything fancy with
the XML. Doesn't look like SQLXMLBulkLoad will work for me as the feed
as an inline schema. I'll have to find another way.

Your point about javascript is well taken, and I've just been lazy
using vbscript.

Incidently MS Access 2003 sucks in this feed in a blink of an eye,
structure and data or just structure. Interesting, but ultimately not
useful as I would want to do directly to MS SQL Server.

Thank you for your help, advice & patience.