X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Extract Web Data, Access 2010    
post Jan 19 2020, 08:14 AM

Posts: 93
Joined: 14-October 10

Hello friends, how are you ?

I would like to know, if anyone has any solution that extracts data from a web page.

I explain:

I would like to click on a button on the form, the data of that site:


Popularized a table, with the fields

Contest - Date - 1A - 2A - 3A - 4A - 5A - Winner - Prize

It would be possible ?

I need to pull this listing as it is in the attachment

Attached File(s)
Attached File  Tela.jpg ( 105.56K )Number of downloads: 8

Access Lean Systems
José Roberto
Facebook Google Plus
Go to the top of the page
post Jan 19 2020, 09:31 AM

UA Moderator
Posts: 77,520
Joined: 19-June 07
From: SunnySandyEggo

Hi. Can you ask the website owner if they provide a web service for this?

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Jan 19 2020, 09:55 AM

UA Admin
Posts: 36,778
Joined: 20-June 02
From: Newcastle, WA

Further to what theDBGuy suggested, this process is commonly referred to as "screen scraping". Many websites frown on it, especially those that offer data services, either free as a public service or for a fee. This sounds like you're trying to scrape winning numbers from a lottery website. Do they even permit that? What do their terms of service say?

The other problem is that the process generally relies on knowing where on a screen certain values are placed. There's no guarantee that a website won't redesign their pages at any time, breaking your VBA.

All in all, the best bet probably is to go to the site and see if you can get the data as a web service.

If you still want to pursue it, though, do a search for "screen scraping". It's been around for a long time and I'm sure you will find numerous posts.
This post has been edited by GroverParkGeorge: Jan 19 2020, 09:56 AM

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
post Jan 19 2020, 10:16 AM

UtterAccess VIP
Posts: 11,604
Joined: 10-February 04
From: South Charleston, WV

Whose website is this? Another company?
You could have a download option already there on the screen. Even a spreadsheet could be used.

Robert Crouser
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    24th February 2020 - 03:01 AM