Link to live external data on web

Resolved · Medium Priority · Version 2007

Mon 18 Jul 2011, 16:15 Delegate Richard said...

Richard has attended:
Access Intermediate course
Access Advanced course

Link to live external data on web

I'd like to be able to link to dynamic data on a web page which contains NHS drug prices that are updated monthly. I notice Access has the ability to link to external html data - is it possible to create a table that obtains it's data from the pricing data contained on the following page
http://www.ppa.org.uk/edt/July_2011/mindex.htm
so that the data held in the access table is updated automatically whenever the wbe page is updated?

Tue 19 Jul 2011, 15:29 Trainer Simon said...

RE: Link to live external data on web

Hi Richard,

Thank you for your question.

I am going to pass this one on to my colleague Anthony who is possibly in a better position to answer this one.

Please give him a small amount of time to respond as he is training today.

Regards

Simon

Thu 6 Oct 2011, 20:09 Trainer Anthony said...

RE: Link to live external data on web

Hi Richard, thanks for your query. The quickest way to achieve this would be to leverage the New Web Query function in Excel, point that at the HTML page and use it to pull in the data you need to a spreadsheet. I would then link that spreadsheet straight into Access. It's not a one button solution, but to achieve that (and any refresh without opening Excel) would require code. See the link below for more on this, plus comments on "Automation Anywhere":

http://www.access-programmers.co.uk/forums/showthread.php?t=213108

Hope this helps,

Anthony

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips