Ok. Create a new database.
Follow the instructions here: www.theofficeexperts.com/access.htm
Pay attention to the field names and such.

One table for Mfrs.
MfgID (autonumber)
MfgName (what's in the Excel as their name)

One table for parts
PartID (autonumber)
PartNo (your part number)
PartDesc
PartMfr (this should be a lookup type field to the other table)

Dont' skip the captions.

I'm right here. Don't struggle. Ask.
You won't believe how easy.