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

    Exportar dados formulários diretamente para o MS Access

    Asked by charlesu2004 on October 31, 2016 at 09:04 AM

    Olá tudo bem?

     

    Primeiramente, gostaria de dar os parabéns pela excelente plataforma e pronto atendimento de vocês. Minha dúvida é a seguinte. Tenho um banco de dados em MS Access e gostaria de trazer os formulários do Jotform diretamente para meu banco de dados do Access de forma automática.

    Existe esta possibilidade? Se sim, qual o caminho?

    Abraço a todos!

    Page URL:
    www.querofinanciar.com/sua-solicitacao-foi-feita-com-sucesso

    ms access JotForm
  • Profile Image
    JotForm Support

    Answered by Boris on October 31, 2016 at 11:21 AM

    You can create an Excel Report from your form submissions, and then import the Excel files into your MS Access:

    https://www.jotform.com/help/101-How-to-create-an-Excel-Report

    Please let us know how it goes.

  • Profile Image

    Answered by charlesu2004 on October 31, 2016 at 11:44 AM
    Olá, muito obrigado pelo contato.

    Na realidade, o que estou buscando é algo automatizado, onde a cada nova entrada de formulário, eu conseguisse automatizar diretamente para o Access, sem intermediação no Excel ou outra ferramenta. Existe essa possibilidade?


    Descrição: Descrição: Descrição: Descrição: Descrição: Descrição: cid:image001.png@01D164D9.257A7C00





    Charles D. Uhlmann

    47 3344-4627

    ANEPS 325997906312004


    Av. Coronel Marcos Konder, 1207 – Sala 45 – Centro
    Itajaí/ SC
    Descrição: Descrição: Descrição: cid:image002.jpg@01D167D3.49A22AE0

    Descrição: Descrição: Descrição: Descrição: Descrição: Descrição: https://static.wixstatic.com/media/4057345bcf57474b96976284050c00df.png/v1/fill/w_50,h_50,al_c,usm_0.66_1.00_0.01/4057345bcf57474b96976284050c00df.png
    _____


    De: JotForm [mailto:noreply@jotform.com]
    Enviada em: segunda-feira, 31 de outubro de 2016 13:21
    Para: charles@querofinanciar.com
    Assunto: Re: Exportar dados formulários diretamente para o MS Access

    A new response has been received:
    JOTFORM
    Answered by Boris
    You can create an Excel Report from your form submissions, and then import the Excel files into your MS Access:
    https://www.jotform.com/help/101-How-to-create-an-Excel-Report
    Please let us know how it goes.
    View this thread on browser » Unsubscribe Thread
    1477927294
    ...
  • Profile Image
    JotForm Support

    Answered by BDAVID on October 31, 2016 at 02:02 PM

    You could accomplish this using PHP, here is an example on how to send submissions to your own database:  https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    You could hire a developer to help you send the data using PHP to your MS access database: http://stackoverflow.com/questions/19807081/how-to-connect-php-with-microsoft-access-database 

    Open a new thread if you need anything else, we will be glad to assist you.