Re: Pull out information from an SQL database

ErnestoM — Fri, 24 Sep 2010 12:41:15 GMT

InfoPath allows you to obtain data from SQL. Please read this article:

http://office.microsoft.com/en-us/infopath-help/add-a-data-connection-to-a-microsoft-sql-server-database-HP010092823.aspx

There are other tutorials available online; a Google search will reveal plenty. Once the data connection is set up, you'll have to set up filtering to display the data as desired.

Submitting to an Access database is an entirely different situation. You could create a database bound form, as detailed in this article:

http://office.microsoft.com/en-ca/infopath-help/submit-form-data-to-a-microsoft-access-database-HA010211754.aspx

However a database bound form means that your database structure and your InfoPath form are permanently bound. You can't easily add fields to the form.

The alternative to a database-bound form is writing your own web service that submits to a database.

There are third party packages available, like DBXL, which make the database query and the database submit easy. However, you'll need SQL and not Access.

Pull out information from an SQL database

TechPundit — Thu, 23 Sep 2010 16:58:59 GMT

Hello I am new to infopath and had a question?

How do I go about doing this: Based on a case number entered in a form, I would like to pull information such as Case Manager, Title, date etc. for a particular case from an SQL database. After this information is collected, the user should be able to fill out the rest of the form manually.

Also, when a form is submitted if I wanted all information in the filled-out form to go into an Access database, how would I go about that.

thanks in advance

Newbie Questions

Re: Pull out information from an SQL database

Pull out information from an SQL database