Importing Data To Existing Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top