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/89625.aspxWed, 08 May 2013 23:30:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:89625Zubertron0https://www.infopathdev.com:443/forums/thread/89625.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=89625<p>Hi all,</p> <p>I&#39;m on the next phase of my project...</p> <p>I have my Infopath form working and am now looking to setting up a database to house the saved form data as xml. This might be more of an Access question but I though I would see what suggestions come back.</p> <p>The idea is to save the form data as xml then import each &quot;quote&quot; (as in quoting for how much a training course will be) into an Access database which will then be linked to a Word doc with a mail merge function to then generate a PDF to send to the customer. Simple enough I thought! But noooo....... not really. The problem I have is the xml data imports fine, but it&#39;s all in separate tables. This means the link to the Word doc can only be done with one table. I have tried various ways to set it up in Access but the problem lies in the xml structure (in my opinion!).</p> <p>What I would like to ask is if anyone out there can suggest a way to have the xml import into Access as one table?</p> <p>As I said, this is probably more an Access question but there might be another solution in the way of structuring the xml or the way the form is set up.</p> <p>So, the form is fairly straight forward with some sections grouped in folders and one repeating table. I have thought about putting all the form fields out into the root structure but the repeating table must be in it&#39;s own folder... </p> <p>Any suggestions would be welcome and if this isn&#39;t suitable for this forum just ignore it! Thanks :) </p>