• 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.