I have a table that is linked to an excel spreadsheet called packdump. The spreadsheet recieves the output of an AS400 query. I would like it if everytime a value changed on the table if it would update a table that I have in the database. I htink that update query is in order, but what will trigger it to look?

Is this table a seperate table from the Linked Excel Spreadsheet?

If it is then you would need to have a manual process that updates it.

Or

Create a timer event that looks at the modification date of the excel file to get a trigger to fire.