- TeapotValleyAsked on January 06, 2015 at 03:17 PM
This is not something that I want done automatically, as there aren't massive amounts that I have to do. But only some of the information is what I need copied over (say, 20 fields). I tried doing a Paste Append but didn't seem to work, even if I matched up the field names between the form and the database.
- JotForm SupportjonathanAnswered on January 06, 2015 at 04:09 PM
There is really no direct export to Access database unlike the other bigger databases like MySQL, DB2 or MSSQL.. you can check them here
You can also use POST Data method to export direct to MySQL
You can test the POST Data anytime.
To what I know, the simplest way to put your submission data to the MS Access database is by exporting the data first as CSV file and then just use the import data from file functionality of MS Access.
You can get the jotform submission data in CSV file format using this guide
When you get the CSV data, you can put it on a directory/folder where you can point from the MS Access were to automatically import the data.
Hope this help. Please let us know if you need further assistance.