I have a table containing 277 fields (I know, I know...did someone say 'relational database'... I didn't design it, I am just working on it for friends in dire need...
I currently have an import process which extracts data from a spreadsheet and then appends it to a staging table identical to the monolithic main table. The user then clicks to run a regular old Update Query which updates the main table with the staging.
The above was on-the-hoof emergency stuff to upload one-off updates to the data, but due to outside issues this has to be used as a regular update feature, urgently. (isn't it always...)
My problem is that these updates are likely to only contain the fields being changed. Therefore the staging table has null values in the fields not being updated. Of course, if I run this update query it will update the new fields, but also blank those which aren't being updated...
If you set a condition not to update a field if it is null, it obviously will not update any fields in that record.
Is there a quick way to get the query to update only those fields which have a value in the staging table? I can write some code to do this but basically by the time I have dusted off the cobwebs, written the code and tested it properly, the hour of need will be past.
Any quick-fixes would be very much appreciated.