UPC info in Excel

[rreynolds63]

OK, I always catch flack from my buddies because I always try and d
crazy things with Excel. Here is one of those ideas. I hope someon
can help me.

Goal: Be able to compile a text list of my CD collection.

My idea/solution: Enter the UPC codes from the CDs and use Excel t
retreive the name info.


I have found a website (http://www.upcdatabase.com/item.pl?upc=) wher
you can enter in a UPC code after the = and it will return a brie
description of your item. The returned data is very standard and is i
text format. My general theory is to have a cell to enter my UPC an
have some type of formula/tool that will lookup that UPC and return th
contents of the description field into another cell. I hope that I hav
described this accurately. The idea is a bit wacky but I am sure ther
is a way to do it.

Thank you all in advance!

Ric

 

[Dave O]

Scanning around on that same website,
http://www.upcdatabase.com/
one of the offerings is a download of the database that drives it. So
you could avoid the web interface entirely, and use Excel or Access to
do some lookups.