I'm starting this project and don't know where to start. Essentially I'm automating a process in my office. I have PDFs in a folder and they are all in the same format. PDFs automatically get sent there from my Email Inbox so it needs to be constantly updating. I need to check certain properties in the table that the PDF is in and can do that through MS Access queries. Access won't be an issue although getting the PDFs into Access is. I need to convert them into Excel files first and then move them directly into the database. Right now everything is handled manually including the process inside the database. When there are over 400 to do it gets repetitive and creates human errors. What I'm asking is where should I start to look for an automated conversion software and/or how do I create one myself (I'm pretty good with code) but just don't know where to begin. I'm sure I missed some information but if you let me know what else you need to help me, I will add it shortly.
Thanks in advance,