Append 2 linked tables together

[sdc1234]

Greetings,

I am trying to append 2 linked (2013 data and 2014 data) excel tables and I get Operation must use an updateable query, does anyone have a workaround this issue....

v/r
novice

[ItsMe]

Create a copy of your database and open the Query object in datasheet view. Try to add a new record and you will not be able to. You may be able to edit some data while in the query DS view in some fields and not others. This is not an updatable query.

In order to create an updatable query the joins must be done in such a way that edits do not violate the joins. Another way you can create a non updateable query is to violate rules you created in the Relationships Window of the DB.