Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Link to live external data on web

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Link to live external data on web

Resolved · Medium Priority · Version 2007

Reply Mon 18 Jul 2011, 16:15Delegate 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?

For upcoming training course dates see: Pricing & availability

Reply Tue 19 Jul 2011, 15:29Trainer 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

Reply Thu 6 Oct 2011, 20:09Trainer 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

Access articles

· How To Use The Analyze Table Tool In Access
· How To Use Referential Integrity In Microsoft Access
· Want to Become the Office Hero? MS Project Training Could be the Answer
· How To Filter And Sort Data In Access 2010 Tables
· User-Level Security In Access

Please browse our web site to find out more about
access vba courses in london and other Microsoft training courses.

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips