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

  • Profile Image
    slespinasse
    Asked 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
    BDAVID
    Answered 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
    Stuart 
    Answered 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
    Nik_C
    Answered 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!