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

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