What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can data from your forms be uploaded to Access Database?Asked by Charlie on January 05, 2017 at 04:05 PM
We run a non profit international technical and cultural exchange program.
People applying to our program need to complete a fairly comprehensive application form. This they currently do as a pdf and send to us.
We use MS Access Database.
Once we have the application, we enter the application data from pdf into Access manually.
Could the data collected on an application form we developed using JotForm uploaded into an Access Database?
Thank you in advance for responding.
It is possible to post your form data submissions to external database. I have not tried posting data from JotForm to Access database yet but since Acess and MSSQL has some similarities, here is a thread enumerating the steps and options to post form data to MSSQL in real-time: https://www.jotform.com/answers/288193-Can-I-have-my-form-submissions-posted-into-my-online-MSSQL-Database
If, on the other hand, you want to export your form data from JotForm and import to your own database, you may use our tool here: http://sqlserver.jotform.io/. The output of using the tool is an SQL file which can be used to import data to SQL Server. Access has a part where you can also run SQL commands so it can be useful.
Other options you can try:
- Send Submission Data via POST Method Using PHP and the Thank You Settings - in this guide, the target database is MySQL (not Access) and it will require you some knowledge in PHP programming.
- You can also export your form submission data to excel and paste/import them to Access.
Let us know if you need further assistance.