I am trying to convert an 800 page PDF file into Excel so I can automatically update pricing information. I have tried a number of different sources and have not had any luck with this conversion. There are programs that will export the data into Excel applications, but it does not do it in a clean format. I have tried all of the basic applications that pop up from a basic Google search and have also tried converting it using the full version of Adobe Acrobat.

Here is a link to the PDF: ttp://www.lcbapps.lcb.state.pa.us/webapp/product_management/Files/productCatalog.PDF

Once I convert that into an organized excel file, I am planning on writing a macro to have it automatically update a pricing field in an inventory spreadsheet. Any thoughts?