[AccessD] xml tables

[John Bartow]

I ran across this tonight while reviewing some (unrelated) documentation but I thought of this thread:
"...aggregate reports are encoded in XML format, which is a data format easy for machines to parse, while time-consuming for humans to read..."
"Manually parsing such data is not much fun and error-prone, especially if you have to do this many times every day. It'd be wise to use an analytics service to automate this process for you..."

LOL, no kidding!

John B

-----Original Message-----
From: AccessD <accessd-bounces+jbartow=winhaven.net at databaseadvisors.com> On Behalf Of Stuart McLachlan
Sent: Tuesday, June 28, 2022 2:35 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] xml tables

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
> 

--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com