Access can do it, can InfoPath 2007?

[VIDRO]

In access 2007 there is a neat function where you can generate an email form
based on an already structured database, send it to a user, have user fill
out this email form send it back , once received the email automatically
populates the database that the original email was structured from. (I would
use Access to generate the email form but I have not found how to control the
data format or screen)
How can I get InfoPath to do what the Access forms email auto generate does?
I have designed a form based on an Access database, I can get the form sent
to an email account but how do I get the InfoPath form after being sent via
email to export its collect data to Access?
I know there is an export to Excel from an InfoPath email but this is not
what I need plus it doesn’t seem to append data to Excel it seems to create a
new file every time you export.

 

[Sheetal D [MSFT]]

Once the user fills out the InfoPath form, you might want to submit the
form to Access database.

Here are some articles which might help:

Submit form data to a Microsoft Access database
http://office.microsoft.com/en-us/infopath/HA102117541033.aspx

An introduction to submitting InfoPath forms
http://office.microsoft.com/en-us/infopath/HA011444861033.aspx

Integrate an InfoPath Form with a Microsoft Access Database [InfoPath 2003
SDK Documentation]
http://msdn2.microsoft.com/en-us/library/aa202738(office.11).aspx

Note: For submitting data to Access database, users need to have access to
the database. You can have the database on a network share where all the
users have access to.


HTH,
Sheetal

This posting is provided "AS IS" with no warranties, and confers no rights.