Not able to use append query

[GeeseWatcher]

In my database, I have one table (Inventory) and a link to an excel sheet
(City).
When I try to build a small append query to attach the City sheet to the
Inventory table, the append query does not give me the option to append to
the Inventory table.

Why is that? The datatypes match, the columns match, and I am stuck.
Please help.

 

[Golfinray]

Use an update query.

 

[GeeseWatcher]

Well, we don't want to update data in the table. We just want to add data to
the existing table. There is no issue with the links to the excel sheet, but
I can't get the query to acknowledge the main inventory taable.

 

[Golfinray]

add a column called "City" and then try appending the data.

 

[Klatuu]

Do you mean add new records to the table, or add values in fields in the
existing records? You description is a bit vague.

You use an Append query to add new records to a table.
You use an Update query to modify value of fields in existing records.

Also, be sure, if it is indeed appending you are trying to do, you are not
attempting to add records to the liked excel sheet. You can't do that
directly from Access (sort of), you have to use the Execute method with SQL
specifically tailored to update Excel files.