Is there a way to export form contacts for re-import into an Access database.

  • lsfocc
    Asked on August 8, 2019 at 7:37 PM

    We are a new user and interested in interfacing with a data base of applicants.

  • John Support Team Lead
    Replied on August 8, 2019 at 7:53 PM

    Hi,

    If you mean exporting your form data then import it to an MS Access Database, you can do that by exporting the submissions to an Excel file first. Here's a guide on How-to-Export-Form-Data-to-Excel

    After that, you can import the data from Excel to Access. Here's a relevant guide for that: Move-data-from-excel-to-access

    Please try that and let us know how it goes.

  • lsfocc
    Replied on August 8, 2019 at 8:03 PM

     Yes, that is a route that should work. Will the export file have field headers than can match to the data base structure?

    We are 1-3 weeks away from having form ready to take to that next step.

  • jherwin
    Replied on August 8, 2019 at 8:33 PM

    Could you please further explain this "have field headers than can match to the database structure"?

    Please note that when you export submissions, the field headers are the same as the field headers in your form.

    Looking forward to your response.

  • lsfocc
    Replied on August 8, 2019 at 8:35 PM

     Perfect. We will set up our data base field names the same as the form.

    Thank you,


    David