pasting to Access

[gogaak]

hello all,
Is there any provision to copy and overwrite a particular portion of data from excel worksheets into Access table based on the primary key match.

I am using MS office 97.

 

[Uncle Gizmo]

No, not to my knowledge. Why not import the information into a temporary table in access and then update the records with an update query?