https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/65898.aspxWed, 13 Apr 2011 15:29:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65898Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/65898.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=65898<p>Hi --</p> <p>You can, in code, probably do this. You can apply an XSLT to the XML so that you can put the right fields in the right columns. I&#39;m not sure how that would work with adding rows to an existing Excel sheet, however. </p> <p>Here are some links that may help you:</p> <p><a href="http://support.microsoft.com/kb/319180">http://support.microsoft.com/kb/319180</a><br /><a href="http://www.techrepublic.com/article/convert-an-xml-file-into-an-excel-spreadsheet-with-this-technique/6163451">http://www.techrepublic.com/article/convert-an-xml-file-into-an-excel-spreadsheet-with-this-technique/6163451</a><br /><a href="http://support.microsoft.com/kb/307322">http://support.microsoft.com/kb/307322</a></p>https://www.infopathdev.com:443/forums/thread/65865.aspxMon, 11 Apr 2011 19:53:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65865PeaceOfficer030https://www.infopathdev.com:443/forums/thread/65865.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=65865<p>Hey All!</p><p>First of all, I&#39;m new to InfoPath - So My&nbsp;knowledge is pretty limited, I apologize in advance for my oblivious questions.</p><p>I am trying to create a form that can be submitted directly to an excel sheet. I want to be able to link the fields to columns on my excel sheet, and everytime a form is submitted it will add to the next empty row.&nbsp; I currently have this working with with 2 different excel sheets (a submit XLS and a master XLS) that are tied together with VB Macros.</p><p>InfoPath, visually, would be much easier for my users for what they are doing (using touch tablets).</p><p>Can I bypass a database and have it submit directly to an excel file?&nbsp; These will be used on small laptops in the field that will not have internet access, so I need for the forms to be able to submit locally.</p><p>Any Ideas???</p><p>Thanks!</p><p>Justin</p>