[AccessD] PDF vs Access

Well, I think you are "stuck" with XML as the file format from the PDF form.
The text format option is just not a viable alternative IMHO.
Here's a great article about the pains of going from XML to Access:
http://www.databasejournal.com/features/msaccess/article.php/10895_3310901_2
/Import-XML-Data-Into-Microsoft-Access.htm

You'll have to build some intelligence in Javascript to pull this off of
course.
If you could find a way to call Access from within Acrobat's javascript
environment,
 that would be the ultimate seamless solution.

Good luck !

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
> Sent: Tuesday, September 01, 2009 2:39 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] PDF vs Access
>
> Hello to the list,
>
> I have ten .pdf files of 2-4 pages each.
> The client wants to have a 'form" that looks just like the
> pdfs and a database and some reports.
>
> I can spend a lot of time recreating the look of the pdf in
> an Access form.
> Or
> I can use Adobe Acrobat Pro to make the pdfs capable of
> capturing data and export to Access.
>
> I am pretty sure that it will take much less time to convert
> the regular pdfs to pdf forms.
>
> But I have had some issues in the past extracting data from
> filled in pdf forms.
>
> I am using A Acrobat Pro 7.
>
> Any opinions???
>
>
>
> TIA
>
> Bob Heygood
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>