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

    exporting results to access

    Asked by Arthur  on May 08, 2015 at 09:08 AM

    I am looking for a way to export the results from a form submission into an access database.

     

    Thanks,

    Art

    exporting thanks access database
  • Profile Image
    JotForm Designer

    Answered by ecem on May 08, 2015 at 09:35 AM

    Hi Art,

    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.

    I hope this helps.

    Best Regards.

    Ecem