[AccessD] xml tables

John Colby jwcolby at gmail.com
Mon Jun 27 21:18:24 CDT 2022


It is html.  Sorry for the confusion.

On Mon, Jun 27, 2022 at 6:26 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Is it XML or HMTL. SInce it's a webpage, I would expect it to be an HTML
> table, not XML.
> The two are very different and need to be handled in different ways.
>
> An  XML table looks like this:
>
> <CATALOG>
> <CD>
> <TITLE>Empire Burlesque</TITLE>
> <ARTIST>Bob Dylan</ARTIST>
> <COUNTRY>USA</COUNTRY>
> <COMPANY>Columbia</COMPANY>
> <PRICE>10.90</PRICE>
> <YEAR>1985</YEAR>
> </CD>
>
> An HTML table look like this:
> <table>
>   <tr>
>     <th>Company</th>
>     <th>Contact</th>
>     <th>Country</th>
>   </tr>
>   <tr>
>     <td>Alfreds Futterkiste</td>
>     <td>Maria Anders</td>
>     <td>Germany</td>
>   </tr>
>   <tr>
>     <td>Centro comercial Moctezuma</td>
>     <td>Francisco Chang</td>
>     <td>Mexico</td>
>   </tr>
> </table>
>
>
>
>
>
> On 27 Jun 2022 at 9:16, John Colby 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting


More information about the AccessD mailing list