Live Updating Access Records from Websites (price tracking)

[Jaws4096]

I've set up a product database in Access for my small business. One of its functions is to track the prices of competing products online.



I'm trying to get Access to automatically update these prices en-mass, yanking the data off the websites in question without me having to manually enter hundreds of prices each week.

I have a unique record for each product instance as it appears online. For example, there are three unique records for a 4oz hand sanitizer I sell (one for each of my competitors that sells it). Each record has the price, quantity, and unique URL on which the product appears.

I'm not great with HTML and don't really have any programming expertise aside from some pretty simple VBASIC.

Is what I'm attempting possible?

[June7]

Supposed to be easy in Excel, don't know if adaptable to Access http://answers.microsoft.com/en-us/o...1-111a841f1846

Possible Access solution
http://www.access-programmers.co.uk/...d.php?t=203572