Updating Query with new table data

[BlueRhinos]

Systematically, I have a prebuilt query that needs updated with the most current data table. In my process, I add the new table to the query and then update each static field with the new table. While the update only takes a couple minutes, it's cumbersome because the query contains lots of fields. I can't use the asterik for all fields, as there are certain fields I need to exclude. Additionally, I don't the computing power to link the my access table to an external excel file. Is there a shortcut that would more efficiently update all fields in the query to reflect the current table? Thanks! -db

 

[CT Witter]

Could you please provide an example of what the query looks like before and after your daily update? Please detail the steps that you take.