Google Answers Logo
View Question
 
Q: Auto-Filler for Microsoft Access Database ( No Answer,   1 Comment )
Question  
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.
Answer  
There is no answer at this time.

Comments  
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.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy