[AccessD] xml tables

[Gustav Brock]

Hi John

As the very first, try to download that page to a file, and then - in Access - create a link to this file.
If in luck, Access will recognize the table within the file. When linked, you can read and manipulate the data as you would do for any other table.

I guess you have code to download a web page; if not, you can use one of those found in my module internet.bas here:

https://github.com/GustavBrock/VBA.PictureUrl

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af John Colby
Sendt: 27. juni 2022 15:17
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>; John W Colby <jwcolby at gmail.com>
Emne: [AccessD] xml tables

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