Hello. Can anyone help? I have an updated tableX in access file1. I would need to transfer those records to access file2.
I imagine it in the way that I read tableX in file1, I read file2 with the key and if the key is the same, I do UPDATE to tableX in file2,
if there is no such key, I do APPEND to tableX in file2.
Is it possible to do it somehow in Access? If so, in what way...
Ondrej