A few Questions/ taught:
*In the Where clause why your not using the Exist function , I feel using that will be more elegant.
*In the second load your using a Resident load from first table or your loading the file again?? if its not Resident load then we might need to check on structure of data.
*If you share the script that do give us a better understanding , to check what's happening
I think I have it now. As I said, when looking at it for the 1.000th time I suddenly noticed that I had written the wrong worksheet_name in the LOAD (i had copied it from an earlier one).
A RESIDENT LOAD would not have worked in that case - I had filtered out certain records in the first loop, and in the second one I wanted exactly those, so a RESIDENT would obviously not give me what I wanted.
I don't quite understand what you mean about an EXISTS clause, but yes, I guess I could have used that as well. There are many ways leading to Rome ...