Simple way to add missing values using a separate excel worksheet?

[naragam]

Hi all,

I'm a newbie to this forum and hope someone can direct me to add a bunch of missing values from a field of an existing ACCESS DB using a separate Excel spreadsheet that has the required values for rows identified by an index variable. I thought I could do a simple merge but I'm not sure I can find a merge function. Any help?

Best, Nash

[xps35]

There is no merge function in Access. You have to build your own.
A way to do this is to link the Excel worksheet to Access. Create an update query joining the linked worksheet (which will act like a table) and your Access table on the "index value". Update missing Access fields with the corresponding Excel values.
This is the best I can do given the limited info provider.

[Welshgasman]

You would use an update query.
Link to the excel sheet and the create a select query first to verify the data, then change it to an update query.

Make a backup of the table first in case it goes wrong.