How do I update my table with an excel spreadsheet?

[Astron2012]

Hi, I would like to know how to import an excel spreadsheet into my existing database to just update the records. I don't want to add any records at the end or link the sheet to the table.
I also don't want to just copy and paste as I don't want my users to have access to the main table but they will need to have the facility to upload.

The reason for this is we have to send clients a copy of their relevant section of the table in a spreadsheet that matches the table format exactly and contains the correct ID numbers. They then send the spreadsheets back to us completed and I would like to update the fields of the existing records using the ID numbers.

I'm pretty sure its a case of using an update query but I have very little knowledge of coding so any help on this would be great.

[June7]

Either link to or import the Excel sheet to a new table. Use that table in an UPDATE query. Could probably build and run an Access query object and not need any code. Just depends how much you want to automate the process. Import/export Excel is a common topic. Search forum and Google.