2. Update the records in excel
3. Create a form (datasheet) in access
4. Select the column(s) you have updated in excel
5. Select the column in the access form
6. Select paste special in access and paste as text
This retains updation in the order of the primary key and is fairly useful if you update based on excel sheets. Its usually better than having a linked table.