I am trying to append data entered thru a form to a table in Microsoft Access. How do i do this?
M Madald Mar 9, 2006 #1 I am trying to append data entered thru a form to a table in Microsoft Access. How do i do this?
S S.Y.M. Wong-A-Ton Mar 10, 2006 #2 You can bind your form to the Access table using "New from Data Connection" when creating your form (search the InfoPath help file on "Design a form based on a database"). Or you can do it programmatically (see http://enterprise-solutions.swits.net/infopath/programmatically-add-db-record-vbscript.htm). Or if your database table contains fields that InfoPath cannot use to submit to (such as memo fields), you could create a web service to submit the data to your database (see http://msdn.microsoft.com/library/d...03_ta/html/OfficeInfoPathWebServiceASPNET.asp).
You can bind your form to the Access table using "New from Data Connection" when creating your form (search the InfoPath help file on "Design a form based on a database"). Or you can do it programmatically (see http://enterprise-solutions.swits.net/infopath/programmatically-add-db-record-vbscript.htm). Or if your database table contains fields that InfoPath cannot use to submit to (such as memo fields), you could create a web service to submit the data to your database (see http://msdn.microsoft.com/library/d...03_ta/html/OfficeInfoPathWebServiceASPNET.asp).
