I have a sharepoint list with sales territory data, where the original data came from a pipe delimited text file. I used access to create the list, however, the text file is updated every day, the number of rows don't change, but individual fields do. What I would like to do is update the records which have changed by comparing the sp list to the data in the text file. I want to loop through each row and build an xml batch element based on that comparison. My first question is, is this the best way to do this or should I be looking at another approach? Second question is what is the best way to pull the nodes in the sharepoint list for comparison?
Any help would be appreciated.