How do I import data into an existing table to update the records?

[Mmmel]

Hi!

I have a table of names and addresses, all keyed off of the student ID number. I want to import email addresses for these records using an Excel spreadsheet that contains only the ID numbers and email addresses. That is, I simply want to add the email addresses to the correct people who are already in my table.

It seems so simple, but how in the heck do I do it? I just can't figure out what to search for to find my answer. My apologies if this has already been answered.

Thanks!

[Mariostg]

Import your excel spreadsheet into a table in your access database.
Execute an update query to set the email address based on matching student ID

[Mmmel]

Great! This was incredibly helpful. Thanks for taking the time to help me out! Got it finished now! : )