O'Reilly logo

Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word by Michael P. Antonovich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9.7. Building Data Connections for Forms

In the first part of this chapter, you saw how to create a basic form that generates XML data files when you submit the form's data. But you can also create an InfoPath form that uses SQL or Access tables as both the source and the destination for data from a form. To do that, you need to create a data connection from the form to the database. Actually, you need two connections, one to select data from the database, and a second to update the database. This section explores the steps needed to created a data connection to a SQL Server database, which you will then use in the next section to build a form to view and update data from one of the tables in that database.

To begin, select the option Design ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required