Cannot figure out an indexing scheme

From: Trent Creekmore <tcreek_at_gt.rr.com>
Date: Fri, 01 Nov 2002 08:26:16 GMT
Message-ID: <IUqw9.255901$121.7225002_at_twister.austin.rr.com>

There is a person who has compiled a database of UPCs (not conplete). The site he runs is www.upcdatabase.com

He has put a small part of the database at http://sourceforge.net/projects/upcdatabase. It contains 2 CSV files. One is the manufactures and the other is items. The manufactures file conatins the first six digits of the UPC to identify the companies. The second file of items does not have the last 5 digits of the items for the UPC code. Instead it is some type of indexing scheme that I cannot figure out. This guy is still working on the database at his sight, but seems to abandoned the work that he is placing on sourceforge. He is also refusing to answer emails I have sent him.

I am looking to import this data into MySQL and MS Access/MS SQL.

I am quite new to dealing with databases.

Here are some parts of the database to view.

From ITEMS

      1.12E+10 1CT SVN COOKWARE SCRUBBER SPONGE

      1.12E+10
       1CT SVN TUB/SINK

      SCRUBBER SPONGE



      1.12E+10


        2CT


      SVN GREEN SCOURING PADS
      1.12E+10
         300 CT
       "VALUE WISE PAPER PLT 9""MAX PAK"

From Manufactures:

      22700    Proctor &
      Gamble
      23000
      Comstock Michigan Fruit Division
      23100
      Kal Kan Foods Inc
      23200
      Western Sugar Co
      23400
      Dial Corp
      23600
      Knouse Foods Inc
      23700
      Tyson Foods Inc

Thanks for any help.

Trent Received on Fri Nov 01 2002 - 09:26:16 CET