IM****TING A SINGLE EXCEL FIELD

I have a field in an access field named ALLOCATIONS.  I want to overwrite 
this field with new data from a field in an excel file (same number of
rows). 
 I can't seem to find the combination of linking or getting external data
to 
make this work.  Can anyone give some guidance?

Thanks,
-- 
William