These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Import returned form data directly into Access

Forum Index > Forms: Acrobat > Import returned form data directly into Access
2008-06-18 06:19:37
RichelleLabelle
Registered: Jun 18 2008
Posts: 4

Does anyone know if it is possible to import the returned data set file directly into MS Access rather than back into the data set and then exporting as CSV from there to then be able to do the import? I'd like to eliminate some steps. Or perhaps I've set up the Submit incorrectly? I've set it to FDF - would HTML data or another be a better choice for this? Thanks for any tips.

My Product Information:
Acrobat Pro 8.1.2, Windows
Top
2008-06-25 07:57:39
#1
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
Is this a LiveCycle form? If so, you can import XML data in Access.
Another option is to use the ADBC (Acrobat Database Connection capability). This is disabled by default in Acrobat 8 but you can enable it. For more information on ADBC visit the following technical note [url=http://kb.adobe.com/selfservice/viewContent.do?externalId=333472]Acrobat database connectivity (ADBC) is not enabled by default (Acrobat 8 on Windows)[/url]

ADBC is suited for simple workflows (i.e., local Access database) but it's not designed for scalability or web applications.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

Top
2008-06-25 09:30:55
#2
RichelleLabelle
Registered: Jun 18 2008
Posts: 4
This is just a form created with Acrobat 8 Pro, not LiveCycle and I am not familiar enough with Javascript to take on that challenge. We'll make do with the export to CSV option. Thank you for your response!
Top