Question Extract PDF Values

[twoplustwo]

Afternoon all,

I am trying to extract some values from a PDF (attached) and write them to an Access database. I am unsure of the approach, especially extracting values from the file.

Thanks for any suggestions.

Cheers

 

[CJ_London]

Not sure if there is a technique for extracting direct from a pdf.

What I do is use another program to convert the pdf to excel and then extract from there. You haven't said which data, but I only look at the first page whereas it looks like you are looking at several pages

There are a number of programs out there, Adobe and Nitro spring to mind which will do this.

 

[spikepl]

I use pdftotext.exe which is part of an open-source XPDF suite - google it.

It spits out text of a pdf file to a text file. It can be launched on a command line with the name of the pdf file as parameter. All this I do in a Shell (google Access shell) that I launch from Access. Subsequently I read the text file and do my stuff with it.

Now I had a look at your PDF : are you sure that the issuer does not offer online data ? On a website or as a web service?