Updating a table 1

[ptrifile]

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

 

[dhookom]

I would import into a temporary table and then run one or more update queries.

Duane
Hook'D on Access
MS Access MVP

 

[ptrifile]

Thanks Dhookom, thats the route I took and its working perfectly. Thank you!