Yea I am running a database in Access 2010 and I was wondering if there is anyway to make it where all I have to do is click the mouse and a program will update my current value in the database to an online price guide? The database is sitting at over 450 items and is constantly growing. Is it possible??? If so, please help.
-
-
Yes, it is possible, maybe. But my experience with MSWinsock, which you may need to scrape the data off the web, has been very hazardous to my mental and emotional wellbeing. So it's wouldn't be my first option for you.
Is it possible to download a file with the pricing so Access can get at the data locally? Or must it be automatically scraped from a website?
Jim -
Sorry, Andrew, there is no in-built facility to do what would really be an action by some kind of magic where neither 'side' of the data knows anything about the other.
Extracting data from a web-based system is feasible, as indeed is automating what you must be doing manually at present, but this is not a trivial or straightforward thing to do.
If you want to pursue the idea I'd suggest that you look at ways to extract data on a regular basis from the web-site in some standardised form - perhaps as some form of XML-based data feed - and then look at importing the difference data into Access. I wouldn't say that this is a quick and easy thing to do, however.
-Stewart
PS Jim replied before me, but please take into account what he is saying about how fraught it can be - it reinforces my feeling that this is not a straghtforward thing to do!Comment
Comment