InfoPath Dev

Hi, I am having a hard time finding a solution in the forums or documentation for this. Here is my problem:

I have an Infopath form that utilizes one repeating table. This form has a repeating table that needs to ultimately be submitted to an existing Sharepoint list when the user submits a form. I understand that the only way to do this within Infopath is to merge the data, but this will not work for me. Apparently I will need to use a SQL table or Access. Just testing, I've actually successfully got the items to submit to a Access table.

Here is where I am stuck. Once submitted to the Access/SQL table, what do I do with the data and how do I get it to my existing Sharepoint list? I am not a programmer, so a in the box solution would be preferred. If coding is required, I do have access to an Internal programmer, but I will have to be very specific in what is needed.

Thanks for your help!

I think what you are looking for is a CAML query.

 You can actually update or insert items into SharePoint using a CAML.  Do a search here on CAML and you can find some instructions.

 Otherwise you would need to use a Business Data Catalog in Sharepoint to try and link to your database data.

Another option, is if you have data in SQL, is to use SQL reports to create web reports which you can embed in SharePoint.

Yes, that is exactly what I am looking for. After doing a little more research I found a codeless solution and a solution that requires coding. The codeless solution will work fine for basic submissions, but will not allow a custom table (as far as I can tell). The solution that requires code (linked below) I believe will work perfect for my scenario. Thanks for the tip!

 Code Solution:

 http://msdn.microsoft.com/en-us/library/cc162745.aspx

 Codeless Solution:

http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx