[AccessD] xml tables
Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jun 28 02:34:45 CDT 2022
That might work with an XML file, but we've since identifed that it's an HTML table in a web
page, which is an entirely different thing. No way will Access identify the table. :(
On 28 Jun 2022 at 6:34, Gustav Brock via AccessD wrote:
> 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
>
More information about the AccessD
mailing list