Access validation using excel spreadsheet data

[cantord]

I want to validate the ProductID in a table using an excel spreadsheet to ensore only the IDs that are listed in the spreadsheet are used in the database. It would be a before update event that will check the spreadsheet for the presence of the ID entered into the form. Can anyone help me with this?

[jzwp11]

You could bring in the spreadsheet as a linked table in Access and then use a form that references that table (via a combo box perhaps). That way the user can only select from products in the linked table (i.e. the spreadsheet) & there would be no need to do any checking.