Updating a table Updating a table ptrifile (TechnicalUser) (OP) 4 Mar 14 09:19 What is the best way to approach importing data from an excel spreadsheet to an existing access table and only importing fields that have changed? Thanks for any help! Paul RE: Updating a table dhookom (Programmer) 4 Mar 14 09:42 I would import into a temporary table and then run one or more update queries. Duane Hook'D on Access MS Access MVP RE: Updating a table ptrifile (TechnicalUser) (OP) 4 Mar 14 10:03 Thanks Dhookom, thats the route I took and its working perfectly. Thank you!