HOW TO TRANSFER DATA FROM FORM TO A DATABASE OR FILE

  • THIERRY
    Asked on February 17, 2020 at 5:29 AM

    Hi  i would like to create a form and have the data sent directly to a access or sql server database is that possible.


    if not is it possible to send it directly to a text file or excel file that is automaticaly stored on a online filer server


    thanks for you help

    thierry

  • Ivaylo JotForm Support
    Replied on February 17, 2020 at 8:11 AM

    Yes, it is possible to send your submission data to a SQL server.

    You can export your form as excel file and then import that excel file to your SQL server.

    Also, you can use MS SQL Server Export application to export your submission data as SQL file. Then you can import that SQL file to your SQL server.

    I hope that this helps.

  • THIERRY
    Replied on February 17, 2020 at 9:50 AM
    New response received

    p img {
    max-width: 100%;
    }




    Hi. Thank you for your answer..
    Is there the possibility of exporting to Microsoft access?
    --
    Sent from my Android phone with mail.com Mail. Please excuse my brevity.On 2/17/20, 14:11 JotForm <noreply@jotform.com> wrote:





    A new response has been received:






    Answered by
    IvayloK


    Yes, it is possible to send your submission data to a SQL server.
    You can export your form as excel file and then import that excel file to your SQL server.
    Also, you can use MS SQL Server Export application to export your submission data as SQL file. Then you can import that SQL file to your SQL server.
    I hope that this helps.




    View this thread on browser »
    Unsubscribe Thread

    1581945066
    ...
  • VincentJay
    Replied on February 17, 2020 at 10:41 AM

    Hi. Thank you for your answer. Is there the possibility of exporting to Microsoft access?

    We do not have an integration with Microsoft Access. You can try exporting the form submissions to Excel and add it to the database.

    Related guide: How-to-Export-Form-Data-t-o-Excel