update table in access from excel using sql

here's the sql statement - UPDATE tbl_RETRO_EFF_76_PREV_WK AS t1 INNERJOIN [tablec] AS t2 ON t1.HIC_NUMBER = t2.HIC_NUMBER set [COMPLETED] =True, [DATE] = #3/17/2014#, [NTID] ='Mike';