How can i link to MS Excel spredsheet or MS Access

  • Profile Image
    REYNDERSRR
    Asked on May 23, 2016 at 08:11 AM

    HI there

    How can i get jotform to add goods to an MS Excel spreadsheet or MS Access page in one form and retrieve the data in another form to update its.

    We have a MS Access database that we would like to take 2 sections of it online for our clients to benefit from it.
    The one is were we would like them to book machine in for repair with there name and surname ....
    The second one is to see the status of there repairs after a week or so were by they can type there info into a form and the form than return the values relevant there info.

    We hope to keep it basic as we would like to do it all in house without outsourcing the job to web developers to help keep cost down and also to make it simple for us to update from the back end online via excel or ms access on our web server.

  • Profile Image
    Huberson
    Answered on May 23, 2016 at 10:33 AM

    Hello,

    If you want to add data collected from your form in a Spreadsheet, you can either Integrate Google Spreadsheet or download your submissions in Excel format from submissions page.

    It is also possible to import data from your Excel document to JotForm using Import Data application - Import-your-Excel-or-CSV-data-into-JotForm.

     

    Do let us know if more assistance is needed.