https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/67439.aspxFri, 17 Jun 2011 00:57:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:67439Patrick Halstead0https://www.infopathdev.com:443/forums/thread/67439.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=67439<p>Hi Caeanis,</p> <p>You might be able to use our XLS to XML tool to do this. It submits to SharePoint and it does handle updates so you don&#39;t have to worry about duplicate writes. You could use the pipe character as your delimiter to create the columns in the XLS. You&#39;re going to need to spend an hour or two learning how to use the tool, but we&#39;re here to help. </p> <p>Best of luck,</p>https://www.infopathdev.com:443/forums/thread/67423.aspxThu, 16 Jun 2011 17:15:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:67423Caeanis0https://www.infopathdev.com:443/forums/thread/67423.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=67423<p>&nbsp;I have a sharepoint list with sales territory data, where the original data came from a pipe delimited text file.&nbsp; I used access to create the list, however, the text file is updated every day, the number of rows don&#39;t change, but individual fields do.&nbsp; 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.&nbsp; I want to loop through each row and build an xml batch element based on that comparison.&nbsp; My first question is, is this the best way to do this or should I be looking at another approach?&nbsp; Second question is what is the best way to pull the nodes in the sharepoint list for comparison?</p><p>&nbsp;</p><p>Any help would be appreciated. <br /></p>