Import External Text File

[5pac3m0nk3y]

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?

[ranman256]

Because this is a bad format, I would use excel VBA to import the text file,
make the corrections (remove header footer) and create new columns : begin,end,capacity.
THEN import the corrected excel file into Access.