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/85549.aspxFri, 21 Dec 2012 01:37:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85549Jim Cantwell0https://www.infopathdev.com:443/forums/thread/85549.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=85549<p>You may want to take evaluate the Excel to InfoPath tool here: <a href="http://www.qdabra.com/en/products/ExcelToInfoPath.aspx">http://www.qdabra.com/en/products/ExcelToInfoPath.aspx</a></p><p>It can take an Excel workbook, and generate xml files based the template you provide.&nbsp; For an InfoPath form you would just use the template.xml from the xsn.&nbsp;&nbsp; A mapping definition you create will determine the how the xml is populated using the row content from the Excel workbook.</p>https://www.infopathdev.com:443/forums/thread/85547.aspxThu, 20 Dec 2012 21:55:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85547Corrie Johnson0https://www.infopathdev.com:443/forums/thread/85547.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=85547<p>This seems like a ridiculously easy question, but my limited knowledge of SP/IP is probably making it harder than it seems.</p><p>I have a weekly data set that I use Access to manipulate and post for monthly manager approval. Right now I&quot;m exporting from Access and posting this in Excel format in a SP Shared Docs and then people email me the changes. For a record set that is almost 4000 records and can vary monthly by +/- 300 records, this is way to manual. </p><p>I ideally would like to take these files (natively Excel), do the manipulation I have to do, post them on SharePoint, set up a workflow in SP to notify them of monthly validation via email (this I know how to do), and then have managers have access to an InfoPath form that they can update and view the data in a user-friendly way.</p><p>The problem I&#39;m having is that for this to work in a form library (copying records from Excel in datasheet mode), I&#39;d have to have a form created for 4000 records that change every week/month.&nbsp; Is there any way to make a process like this work? </p><p>I&#39;m probably not making much sense, so let me know where I need to clarify. I have a very out-dated background in development, so I might need a little hand holding.</p><p>Thanks in advance! <br /></p>