Append Query

[amfroehlich]

I have linked a excel worksheet to Access and I am trying to run an append query on that table, so I can update my tables. The columns in the Query are Item, Program Cost, and Approved. To eliminate some of the rows I had to put these criteria for the item column:

<>"Total" And <>"Earned" And <>"Billed"

Now I am trying to append this query to a programs table, i am having problems because in that table the Items are saved as ItemNumber.

So how can i get this query to insert the Item number instead of the items title into the programs table, without losing my criteria?

 

[jmersing]

I think you should change the structure of your query to :

Select Item, [Program Cost], Approved
from yourtable
where item not in ("Total","Earned","Billed")

I'm not sure if understand the rest of your question