New column in Excel append to Access table

Where/how do you want to append the data?

Where does Department come from?

Does the table already have a pk?

But how do you get the Dept PK for the FTC you are appending to the FTC table?

PS Why not use an autonumber for the PK of the table?

Its in the Department table. In excel there are the departments in there with their FTC values. I'm just wanting to automatically append those to the table if they are new.

So for instance:
Excel Sheet:

Date ----- Dept ----- FTC
05/1/15 ----- 6200 ----- 78%
05/8/15 ----- 6200 ----- 80%
05/15/15 ----- 6200 ----- 87% (Let's say this is the new record)

I want to run a macro that recognizes that this record is new, then when it sees it appends it to a table in Access (the FTC table).

I made the PK Dept and Date in Access because there can't be duplicate data for the Dept and Date (there is always one entry for the day). The original plan was to just append the whole table to Access every week and the PK's would only append new values and not duplicate (which wouldn't work with an auto number field).

Hope that helps convey what I'm trying to do.