[AccessD] xml tables

[Ryan W]

John,
 What's the back end?  If it's SQL Server, why not pull the HTML in and
shred it with SQL server and then use the shredded data (now in a table)
how you see fit?



On Mon, Jun 27, 2022 at 8:16 AM John Colby <jwcolby at gmail.com> wrote:

> Does anyone have a good resource on how to work with xml tables?  I have an
> application where I read the html from a web page.  This HTML has a table
> of info about a user and I need to parse out specific pieces and pull it
> into my database.  The data is in a table, with all of the associated table
> and field tags.
>
> I do a brute force parse to extract what I want but I just know that there
> is a way to pull the table out and iterate the rows.  I like clean and
> brute force parse is NOT clean.
>
> I am currently referencing the Microsoft XML v6.0 for working with xml. I
> don't use it much and have minimal knowledge of it.  Any tips or example
> code would be appreciated.
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>