Importing PDF file into Access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a fillable PDF file and I need the information in the PDF to be automatically imported into an access database. The PDF consists of 2 pages and has well over 50 different boxes that have to be filled out (its a shipping/receiving form
For each record there could be more then one pdf file. I would like to automate the process as much as possible. The pdf file would exist on a network drive and the user would need to go to their record in Access and then link the pdf files.
I started but am having problems with Access not opening the pdf file, it will open word files but not pdf,
I have a folder with multiple files in, some .doc, .pdf , .msg, .jpg and I was wondering if there was anyway of producing a single pdf file of of these. It would have to be automatedand I will be doing this multiple times.
I have managed to get the list of filenames into Access and into a table (thanks to Allen Browne!).
I think there are two ways of doing this.
1. Create a PDF of each file in the folder and then merge them together
The problem I see with doing it this way is how do you create a pdf of a file that isn't open(aka the .doc)? Or create pdf of a jpg from within Access?
2. Create one file, no merging, of each of the files.
I am open to importing and then encoding within the code inside the application.or .converting before importing into ACCESS. Any suggestions (other than "run away")? hints? solutions
Plan - Hyperlink field in a form which would pull up a saved PDF of a saved invoice.
Problem - added Hyperlink - used edit hyperlink function to look up and add PDF file which is saved on PC to the field but the PDF will not open. Tried the same with a word file - it will open.
Question - Can Access 2003 open a PDF file? If so - how can I fix this. If not, will I have to reformat the file to be JPeg or something like that?
The file started out as a pdf file converted to a text file
Now I want ot import the text file in colums.
Not sure how to do it.
The file contains parts #, description, qty and price
I've included the txt file that I'm trying to use, not even sure if I'm going
about this the right way.
I might even have to vb a script to read into an array.
This is so I don't have to type in all the info I can just read the file
minupilate it to my likeings.
I have checked out a number of PDFto EXCEL/Word applications, but the workflow required is far from ideal.
In a PDF-reader, I can Save As a .txt-file. I could decode that output in VBA. I'd prefer to keep the entire cycle within Access, but how do I from Access convince a PDF-reader to do a Save As .txt ? Some shell script? Key-logger?