|
|
Subject:
Auto-Filler for Microsoft Access Database
Category: Computers > Software Asked by: computergod33-ga List Price: $15.00 |
Posted:
06 Mar 2005 09:08 PST
Expires: 05 Apr 2005 10:08 PDT Question ID: 485656 |
I have started a Mirosoft Access Database Table for my DVD Movie Collection. I have a Column for Movie Title, Attributes (Widescreen - WS, Fullscreen - FS, etc. ), Type & Description. I don't mind typing in the Title and Attributes, but i would somehow like the Type (Comedy - C, Horror - H) and Description (Quick Info. ) to be auto-filled from the web. I know this is possible with some macro. Do I need to change it from a table to something else? Is it just a simple macro that can grab that info. from imdb.com? Thank you. |
|
There is no answer at this time. |
|
Subject:
Re: Auto-Filler for Microsoft Access Database
From: willcodeforfood-ga on 14 Mar 2005 12:52 PST |
This is not a trivial problem and there is no simple macro action in Access that can just make this happen. Fortunately, the site you refer to does allow you to download their database contents [ http://www.imdb.com/interfaces ]. If these files were not available, the effort required to get the information would make manual data entry simpler than automation. Here's the general strategy I'd follow if I were tackling this problem: Start by getting a copy of the file(s) from that website in text format. Import each text file into a table in your database. Then write a query that puts information from the imported tables into your tables. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |