PDF to MS-access

[harkirat777]

Hi

I want to take out the data from a PDF form and import into a MS-access database. What is the best way of doing this?
I have tried a simple example as follows and works fine:

1. Create a PDF form using acrobat with the field name same as in MS database
2. Export the PDF field data as XML
3. Importing XML in MS-access using access form and VBA.

This works fine, however, my question is, is there a better way of doing this?
Will it work efficiently for the PDFs with 100 fields?

Thanks
Harkirat

 

[Pat Hartman]

I'm not sure how you would automate this. Do you have a full version of Adobe? Does it support OLE automation?

 

[Mr Smin]

I think harkirat already has automated but needs to know if process will scale if there are more fields.

harkirat, my guess is that importing xml to access will not be a problem even if there are 100 fields. You might find the import process takes proportionately more time.

edit to add: have you considered any other data gathering tools such as web forms?