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/91516.aspxSun, 21 Jul 2013 00:47:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:91516Patrick Halstead0https://www.infopathdev.com:443/forums/thread/91516.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=91516<p>Hi Bonz2012 and welcome,</p> <p>This has been one of the top questions over the last 10 years.</p> <p>Sorry to hear you gave up. </p> <p>Here are the correct solutions:</p> <ul> <li> <div>Map the data to separate parent-child lists using CAML and connect to Excel (out-of-box, no code needed) - lots of posts on this and multiple YouTube webinars from Qdabra</div></li> <ul> <li> <div>Note: Excel 2007 supports binding to a SharePoint list but only if the list created from Excel first (unfortunately, this doesn&#39;t work for Excel 2010)</div></li> <li> <div>Note2: for Excel 2010, you can do a parent lookup on the second list and export from that to Excel (manual)</div></li></ul> <li> <div>Map the data to separate parent-child lists using qRules and connect to Excel (third party tool needed, but free trial available) - this is easier and less cost to maintain</div></li> <li> <div>Map the data to SQL using BCS and connect Excel to that</div></li> <ul> <li> <div>Note: BCS is a pain and doesn&#39;t work for parent-child, but you could flatten the parent</div></li></ul> <li> <div>Map the data to SQL using Qdabra&#39;s DBXL Web service and connect to Excel</div></li> <ul> <li> <div>Fast and easy - we created this to solve this problem in 2004</div></li></ul></ul> <p>Please let us know if you need a flashlight to make it through the forest.</p>https://www.infopathdev.com:443/forums/thread/91502.aspxFri, 19 Jul 2013 18:14:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:91502Bonz20120https://www.infopathdev.com:443/forums/thread/91502.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=91502<p>Good afternoon to you all,</p><p>A colleague and I have been working on extracting to Excel all the data in a sharepoint submitted form that contains a repeating section embedded within another repeating section.&nbsp; Eventually we gave up and eliminated the main repeating section and decided upon having a form per customer entry that has only one repeating section.&nbsp; This is a fix but extremely non user friendly and inefficient. Could anyone please help? I&#39;ve found some posts and details on what I could possibly do but they&#39;ve all led me to non working solutions as well as the fact that I am very inexperienced.</p>