Batch importing PDF form data into access

[bjd1020]

I am sure this question has been asked a million times.......I recieve about 20 to 30 PDF forms a day for service requests....I would like to know if there is a way to batch extract the info from the fields into an access database. I have basic VBA experience and no javascript. Any help would be appreciated.

[June7]

Here is discussion of writing data from Access to PDF form. Should be able to reverse the procedure. http://www.vbaexpress.com/forum/showthread.php?t=21503

If you want to provide your PDF form, I will experiment with.

[bjd1020]

I am sure this question has been asked a million times.......I recieve about 20 to 30 PDF forms a day for service requests....I would like to know if there is a way to batch extract the info from the fields into an access database. I have basic VBA experience and no javascript. Any help would be appreciated.

I wish I could do that, but the form includes sensitve information on it.

[June7]

A blank form is sensitive?

[bjd1020]

A blank form is sensitive?

Its not entirely blank.

Could you use a generic form of some sort?

[June7]

I need a fill-in form pdf. I don't have any and don't want to build. If you can't provide one for testing purposes, then I can't validate code. Can you modify the sample code to do import? That's what I would be attempting. It might be simply reversing the control references. I presume the fill-in boxes on the PDF have names. If the names are the same as fields, then maybe like:

If f.Type="Text" Then Me(f.Name)=f.Value

But that is speculation. Test it and let me know what happens.

[bjd1020]

I know I was asking a lot. I pm'ed you the form. The fields that I need to be transferred are highlighted.

[bjd1020]

I couldnt attach the form to a PM, can you PM me your email so I can send the form???

[June7]

You can attach a file to post or upload to a fileshare site such as Box.com and post or pm link to file.