https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/72100.aspxWed, 16 Nov 2011 02:12:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:72100Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/72100.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=72100<p>Hi:</p><p>I think you are saying that you have repeating data in your form, thus promoting it to your SharePoint library is not adequate for your user. But does your user not have the option to export to Excel from within InfoPath? That functionality has been in InfoPath for awhile - <a href="http://office.microsoft.com/en-us/infopath-help/introduction-to-importing-and-exporting-form-data-and-form-templates-HA010213346.aspx?CTT=1#BM4">this</a> link may help you.</p><p>As to storing in SQL, sadly, if you didn&#39;t build your form off a SQL database, you&#39;ll need either code or a web service for submitting your data to SQL. The company I work for has built a great web service for this - more <a href="http://www.qdabra.com/en/products/DBXL.aspx">here</a>.</p><p>BDC - I&#39;m not as familiar with. But this <a href="http://msdn.microsoft.com/en-us/library/ms551230(v=office.12).aspx">link</a> makes it sound like what is called External Lists in SharePoint 2010 - that is, a way to expose and work with data from other sources, like SQL.</p><p>Hope this info helps you!</p>https://www.infopathdev.com:443/forums/thread/72017.aspxMon, 14 Nov 2011 12:55:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:72017vishal1130https://www.infopathdev.com:443/forums/thread/72017.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=72017<p>Hi Hillary/All,</p> <p>I really like the way how patiently u answer everyones queries.And, your answers are really insightful and helpful to everyone&nbsp;who is seeing them for some guidance&nbsp;. And, it would be really nice of u if u can help me on an issue i am facing.</p> <p>i use infopath for the sharepoint 2007 here i have a requirement of allowing the user to export the values to an excel sheet he creaes <br />i can use the export to spread sheet option but the problem is the rows of data which will be shown are in infopath form <br />and when the form comes up i dont get the option export to spreadheet .</p> <p>How do i do it?</p> <p>Secondly, for storing values in a backend MS -SQL Server</p> <p>And, one more issue , what is BDC? and, how is it related to MS SQL - infopath. As, some body said it is not available so the SQL and infopath cant directly communicate</p> <p>Please explain me the situation and guide me with some new links.</p> <p>Some one was suggesting me a way of putting all&nbsp;the data in the excel sheet and making the excel sheet communicate with the access / sql?</p> <p>&nbsp;</p> <p>&nbsp;Thanks</p> <p>&nbsp;</p> <p>&nbsp;</p>