Problem with linked table

I have two Exell linked tables, i want to update the one with information from the other one. I made a Update Query and when I run the Update Query to update the data on my linked tables, I got a message saying: "Operation must use an updatable query".

When i dont link the tables and just import the tables the same Update Query works.

Any ideas how can I resolve this problem?

re: Problem with linked table

Could you post the SQL for your update query? The use of linked tables in Excel of itself should not stop a query from being updatable. Unfortunately, Access can be quite picky about what it considers updatable, and including just one calculated aggregate (a total of some kind, say) will render a query non-updatable. As another example, selecting the key from the 'wrong side' of a 1-many relationship will render a query non-updatable.

In the meantime until you post the SQL for your update I suggest you look at the following item from the the Microsoft Knowledge Base which provides a full list of circumstances in which Access tables are not updatable.

-Stewart