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
> Connecting To Website, Access 2016    
post Mar 7 2018, 07:34 AM

Posts: 702
Joined: 20-October 05

Excel offers the capability to connect to a random website and bring in a table, but it appears that Access 2016 does not (only as seen below). Am I missing something? How can I *easily* pull in (on the fly) data from the web?



Attached File  2018_03_07_7_32_08.jpg ( 43.58K )Number of downloads: 1
Go to the top of the page
post Mar 7 2018, 08:08 AM

Posts: 1,744
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL

There are articles re getting data from website to msAccess table-- usually found with google "scraping data from website".
Here is one article
and another from same people.

More web scraping info from Dev-hut (Daniel Pinneault)

Good luck with your project!
Go to the top of the page
post Mar 7 2018, 09:19 AM

UA Admin
Posts: 32,096
Joined: 20-June 02
From: Newcastle, WA

In depends, in part, on what you mean by "connecting to a website". It sounds like you want to download data from a website, which is nominally presented in a tabular format. You can do that in more than one way, as the links provided illustrate.

Keep in mind, however, that many websites do not support scraping their websites, especially those which offer access to a data stream, either free or paid. Before you go to far in that direction, therefore, you might want to determine if that's the case with the data in which you are interested.

Also, many sites that do offer data services provide for a way to get that data via a web service. Again, I'd urge you to contact the administrators of the site to determine if that's a better possibility.

For one thing, websites can, and do, undergo modifications from time to time. There's no guarantee, therefore, that the data you want will always be available in the same format, meaning your tool will also have to be modified to match. If this is intended to be an on-going process, it's probably more efficient to get on top of it from the beginning.

Go to the top of the page
post Mar 7 2018, 09:27 AM

Posts: 702
Joined: 20-October 05

Thanks so much Orange999 and George!!
Have a great day
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    18th March 2018 - 08:24 PM