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.


  • Profile Image

    Is it possible to copy the results of a completed form and paste the multiple fields into my access database?

    Asked by TeapotValley on January 06, 2015 at 03:17 PM

    This is not something that I want done automatically, as there aren't massive amounts that I have to do. But only some of the information is what I need copied over (say, 20 fields). I tried doing a Paste Append but didn't seem to work, even if I matched up the field names between the form and the database.

    multiple fields field names information access database database export import database
  • Profile Image
    JotForm Support

    Answered by jonathan on January 06, 2015 at 04:09 PM

    Hi,

    There is really no direct export to Access database unlike the other bigger databases like MySQL, DB2 or MSSQL.. you can check them here

    JotForm Data Management Apps

    MySQL

    MSSQL

    DB2

    You can also use POST Data method to export direct to MySQL

    user guide: -How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    You can test the POST Data anytime.

     

    To what I know, the simplest way to put your submission data to the MS Access database is by exporting the data first as CSV file and then just use the import data from file functionality of MS Access.

    You can get the jotform submission data in CSV file format using this guide

    -How-to-create-a-CSV-Report

    or

    -How-to-Partially-Download-Form-Submissions-as-Excel-CSV-PDF

    When you get the CSV data, you can put it on a directory/folder where you can point from the MS Access were to automatically import the data.

    Hope this help. Please let us know if you need further assistance.

    Thanks.