Hello,
I'm trying to get the information contained in a PDF report into access. I've tried converting the PDF into numerous formats -- .txt, .html, .doc, .xml etc. But the problem is that I want to populate a database table with the columns as such: COURSE, START_DATA, END_DATE, NAME, COURSE_ID, STUDENT_STATUS. Any conversion I do always results in a header containing the course info, the start and end dates.
There's an example in a screenshot attached.
Since this is one example from a report with several hundred pages, manually editing the headers seems like a massive tasks.
In the end it would look like a row of COURSE for every user rather than one instance of it on the top. How could you automate getting the COURSE info and the START_DATE, and END_DATE into Access?