https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/26735.aspxTue, 26 Feb 2008 03:41:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:26735Clay Fox0https://www.infopathdev.com:443/forums/thread/26735.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=26735<p>Hi Charles, Welcome to the forum.</p> <p>You are trying to aggregate multiple form&#39;s data into&nbsp;one spreadsheet?</p> <p>This is a common desire but typically is done using a common database.</p> <p>Capture the InfoPath data into seperate records in a database and then use Excel to connect to the database and analyze the data.</p> <p>You are trying to import the XML directly it sounds like but the issue would be trying to merge the multiple InfoPath forms.</p>https://www.infopathdev.com:443/forums/thread/26731.aspxTue, 26 Feb 2008 03:24:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:26731Charles Heywood0https://www.infopathdev.com:443/forums/thread/26731.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=26731<p>&nbsp;</p> <p>This may take 10 seconds for a knowledgeable person but it&#39;s been driving me nuts for hours...</p> <p>Using Office professional 2003. I am trying to import data from an infopath form into a database in excel so that each new repetition of the form doesn&#39;t overwrite the previous i.e. is added to the next empty row. (I&#39;ve created an xml map so that each form&#39;s data is on one row in excel.)&nbsp;This should be possible but when I go to&nbsp;data/xml/xml map properties in excel the &quot;append new data to existing xml lists&quot; tick box is greyed over and can&#39;t be used. Anyone know why this is or have a solution ? </p> <p>thanks</p> <p>Charles Heywood</p> <p>Auckland</p> <p>New Zealand</p>