When you run an append query, Access does create a temporary table (otherwise, cancel would not be an option). However, it gets a unique name, it is not in the list of tables while it's running, and of course disappears once it's complete.
I don't see any reference to that "table" name in your SQL. Could you post the db?