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.
I want to develop (create) a database using MS Access 2007 or 2010 about Amazon.com.
My ideas are:
1. Create a form to lookup items in the actual amazon website, and then sort the results of the search.
2. View the results. If I select Add to Cart or Add to Wish List, send the item information to my Access database.
Can anyone please tell me how to do those two steps? I really need help!