Importing Data To Existing Records

[Aviador380]

Hello, I currently have a table which lists all staff, I also have an Excel
spreadsheet that contains the number of hours that each member of staff works
each week. I would like to use the data in the spreadsheet to update a new
"hours" field in the database, how can I do this?

The primary key for my database is the staff number, this is also in the
spreedsheet.

Many thanks for any advice.
Paul

 

[Sajit]

Don't know whether it is this simple, but this is what I think you should do.

Link the excel data as a table in Access. Create a Update query based on the
Access table and the spreadsheet table. Link on the staff number.

If you have already tried this, why did it not work?