An append query here won't work because one of the things I'm importing is a key field. If it already exists, I just want Access to throw whatever I'm importing into specific fields. If it does not exist, append it along with its information to the existing table. I have a split database. I tried an update query and nothing happened. I wish I could post sample data but there's just too much stuff in my database already.
My excel book has just one sheet where I do some calculations and filtering. When I get it down to what I need, I want to import only certain columns into access fields BASED on the key column (field). I do not want the entire table overwritten. This is more of an update than anything.