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?
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
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
