partial update of table by importing 1

[cochise]

Is there a way to import data from an Excel spreadsheet into an existing table, but only replace certain fields from certain records? The fields would be the same for all updated records.

 

[PHV]

Why not playing with a temporary table for the import, or even a linked table to the spreadsheet, and then an update query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244