UtterAccess.com
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    
 
   
Joserobmoraes
post Jan 19 2020, 08:14 AM
Post#1



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:

https://loteriadacaixa.net.br/quina/todos-o...-da-quina/29667

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
www.accessleansystems.com.br
Facebook Google Plus
Go to the top of the page
 
theDBguy
post Jan 19 2020, 09:31 AM
Post#2


UA Moderator
Posts: 77,506
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
 
GroverParkGeorge
post Jan 19 2020, 09:55 AM
Post#3


UA Admin
Posts: 36,771
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
 
projecttoday
post Jan 19 2020, 10:16 AM
Post#4


UtterAccess VIP
Posts: 11,595
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    21st February 2020 - 10:34 AM