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

    When I import my CSV file into MS Access, I get #NUM! errors.

    Asked by slespinasse on December 08, 2016 at 03:25 PM

    Two of the fields are JotForm fields (submission ID and submission date).  The other two are Case # and a field that I deleted (another Date field).


  • Profile Image
    JotForm Support

    Answered by BDAVID on December 08, 2016 at 07:21 PM

    I am not familiar with Access database, but following some basic guides on how to import a CSV file, I imported the one from your form, and it worked fine: http://www.ip2location.com/how-to-import-csv-into-ms-access 

    Please contact your database administrator, because this process is not part of our scope.

  • Profile Image

    Answered by Stuart  on June 27, 2017 at 04:17 AM

    Can i apply jotform fields to the access database i downloaded from this source https://access-templates.com ?
  • Profile Image
    JotForm Support

    Answered by Nik_C on June 27, 2017 at 04:32 AM

    @ Stuart,

    I opened a separate thread for your question and we'll attend it here: https://www.jotform.com/answers/1184626

    Thank you!