If you know VBA in Excel write the code to open the database and insert the data from Excel in a table. Use Google to find examples.
I never use SSIS to import data from a native Excel file.
Make a macro in Excel which opens the file and save the sheet with the data
as a TAB separated textfile. Then use SSIS or bulkinsert to import the textfile
in a staging table to compare with existing data.