JotForm Data to MS Access

I have read the posts in regard to this issue.  Is there a way to have the data go automatically to MS Access?

http://form.jotform.us/form/52151242264142

Hi,

This is possible using the Send Post Data feature or using Webhooks integration. You will need a basic understanding on PHP for this to work. For more information regarding Send Post Data feature and Webhooks, you can check the following articles:

1. Send Instant Submission Notifications with Webhooks

2. How to Post Submission Data to Thank You Page

3. Send POST Data From JotForm Using PHP in Custom Thank You Page

4. How to send Submissions to Your MySQL Database Using PHP

5. Webhook Samples

The process would be just like in #4 link but instead of inserting it to MySQL Database you will insert it to MS Access database.

Hope this helps. Do let us know if you need further assistance.

Regards.

We use Access.  I know we can copy and past from the spreadsheet to Access.  But I would like the data from our JotForm to go to a spreadsheet (excel or google drive) and have the output look like the link below.  When a member fills in the form and picks an activity, the spreadsheet will show "True".  And when a member does not pick the activity, the spreadsheet will show "False".

Also, can the spreadsheet show the form of payment...check, PayPal, Cash?

https://www.dropbox.com/home?preview=Sample+MIWC+Membership8-4-15-3.xlsx

You can automatically send your submission data to a Google Docs spreadsheet:

http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

However, it is not possible to send the data automatically to an Excel spreadsheet.  The output format cannot be edited and any information that needs to be included would need to be included as options in the form.  If you need to know the form of payment, you would need to have the option in your form to select the form of payment.