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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Imported data into new records 4
How to export to Excel 2
Import problems from Excel 2000 - Access 2000 3
Importing Amended Data 1
Creating a Complex Timesheet Record 1
Append Query Issue 0
importing designated fields from excel using key field 3
Construct staff pay timesheet 1

Back
Top