by Kees_B - 11/27/11 4:08 AM
In Reply to: MS Access: help to lookup items & sends item info to databas by fetoo86
Well, external datasources in Access have to be accessible in one of the following ways:
- address book or MAPI-folder in MS Exchange
- a Sharepoint site
- an ODBC driver
So the first step is to contact Amazon and ask them for details about their database and how to access it. I'm afraid they won't tell you.
So you need to do screenscraping. Write a VBA module that sends the right search URL to Amazon, and parses the answer. Then put the articles found by that parsing in a table and show that. If you've done that succesfully, you'll find it trivial to select an item from the result list and store it in another table.
http://www.tek-tips.com/viewthread.cfm?qid=1497399 tells how to call an URL and save the answer in a file. But the last part isn't even necessary.
Sorting, by the way, isn't done in step 1. It's only done in query that fills the form you use to view the results.