How can you convert a PDF to Excel format or Import into Access? THru VBA

[Pack10]

We get a number of PDF files every week that we would like to convert to data to import into a database to update and report on.
Is it possible to convert a PDF programmatically (VBA) to convert to excel for later import into Access DB?

 

[dhookom]

I doubt you will have much luck but you might try Nuance PDF Professional to convert PDF into Word and then use automation to pull from Word.

Here is another resource from theDBGuy

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

It is just my wild guess, but those PDF files are probably created out of some data in the data base or from Excel files. Can you ask whoever provides you with PDF file to give you the data in Excel format?


Have fun.

---- Andy

 

[Pack10]

Thats my plan...but I have been told, "Good luck!"...