Need to extract data from an excel file which has html code

I am attaching a file with some HTML code that I need to extract information into an access table.  Can some one provide some guidance?  I have highlighted in blue some of the information that i need to extract.
Report123_test.xlsx
VGuerra67Asked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
It might be easier to read the html file (page) directly.
0
 
Ares KurkluSoftware EngineerCommented:
Can you just use lynx http://lynx.browser.org/ ?
You can dump the page into a text file which will strip all the html.
0
 
Gustav BrockConnect With a Mentor CIOCommented:
If you have the URL, you can download the page using the function DownloadFile  found here:

Show pictures directly from URLs in Access forms and reports

as in this example:

' Download a page: 
Url = "https://www.codeproject.com/Tips/1022704/Rounding-Values-Up-Down-By-Or-To-Significant-Figur?display=Print" 
FileName = "C:\Test\CodeProject1022704.html" 
Result = DownloadFile(Url, FileName)

Open in new window

Acces should be able to attach the downloaded file - or the tables in this - directly, for you to read the information. If not, you will have to open the file as a text file and parse it, searching for keywords and then read the corresponding values.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.