Import some data to existing records?

[kate10123]

Hi everyone!

I know how to import spreadsheet data into an access database but only whole data for a new table.

Is it possible to import certain fields for certain records that already exist in a database table?

For example, if I have a student in the student table who exists in the table with the ID 354849 and I want to import their nationality from a spreadsheet, is this possible without overwriting the whole record or creating duplicates?

Any advice appreciated!

Kate

 

[Kiwiman]

Howzit

Import the spreadsheet into a staging table, then run an update query from the staging table to your main table, joining the two on your id field.