Infopath to Ms Sql server help.....

[J Database DC]

I have an infopath form that has been filled out and deployed into a XML
file. My dilemma is that I need to be able to submit the information from
this XML form into a database that has been built. The problem with this
process is that the infopath form was built before the database. Can anyone
please help me out with the process of taking the XML form and submitting the
information from this form into a database. From what I understand a web
service might need to be added into the mix, however i am a newbie to both
web services and to microsoft infopath. Any suggestions welcomed and
appreciated!

 

[matthew.blank]

The easiest (and least confusing method) would probably be to modify
the source form and add a secondary database for submitting the data
to. You can set up a block of rules attached to a button that copies
the information from the XML fields to the SQL/Access fields and then
submits the data when this button is clicked. If you're using the fully
trusted forms and had to install the form on every user's computer,
then you will have to reinstall again once updated. Otherwise if they
are accessing this form via a share you can just update the share form.
Hopefully this helps.