Access: Tables and Query

Hi all,

I'm new in using Access 2003. trying to figure out how to update a file with duplicates. I have an existing file called TABLe and i have a new file to upload to the current file.
for example:

table1 field contains:
Partnum
Mfrnum
TYPE
Price

Partnum has 8 items with duplicate partnums but
diff TYPE.

How do i fix it in order to upload to the current file with no problem and also will include the duplicate partnums with diff TYPE?

Thanks for the help