Okay, so I know this question has been asked before. I have read and researched the answers. I have small amount data that needs updating. This is not adding or subtracting records, but updating fields in existing records. So , it's down to VBA with SOAP or ADO ( just a front end developer, no powershell server side programming). Or am I missing something ? Just want to make sure.
This will only be done once a month, 25 records out of 2500.
PS yes, the changes could be done manually, but they want a programatic solution.