?
Solved

Is it possible to read the text of a PDF file into Access 2007 using VBA? If so, how?

Posted on 2009-04-09
6
Medium Priority
?
561 Views
Last Modified: 2013-11-27
As a result of help with a previous related question "How can I read text documents (e.g. Word 2007 and PDF) into Access 2007 using VBA?" I can now import the text of single .txt files and .doc and .docx Word documents to Access using VBA. I am now very interested to learn if there is any way a PDF file (or several PDF files) can be read into a VBA Varable or Access 2007 table automatically. I would be very grateful for any help on this...
0
Comment
Question by:DataTrain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 800 total points
ID: 24106647
I don't know much about this but I'm pretty sure you are going to need some third party software to read from pdf files.  Adobe produce a SDK for developers to extract text from docs created using theire pdf writer and other companies produce tools (for sale) to convert pdfs to text.
0
 

Accepted Solution

by:
DataTrain earned 0 total points
ID: 24107337
That is helpful. I have emailed Adobe with a question about this. Does anyone else have experience of interection with text from PDF files under software control??
0
 

Author Comment

by:DataTrain
ID: 24108683
Adobe say I just need Adobe Reader 9 which I already have installed. I can't figure out how this helps me. Do I need to select a Library from Tools/References - if so I can't see anything that looks right. Beyond that what VBA commands do I use. I have contacted Adobe again through their support site but would still value any other input or ideas.........???
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 200 total points
ID: 24115449
Just a side note here.

The maximum amount of charachters allowed in an Access field is 65,000 (Memo), many PDF files exceed this limit.

JeffCoachman
0
 

Author Comment

by:DataTrain
ID: 24116608
That may not matter as I am most interested in the first page or so. I just don't know how or if it is possible!!
0
 

Author Comment

by:DataTrain
ID: 24117003
I don't think this is getting anywhere. The best I can think of is to use a PDF to Word converter and then import the text from Word. The converter I found is:

http://www.soliddocuments.com/products.htm?product=SolidConverterPDF

If anyone knows a method of directly importing the text of a PDF into Access VBA please let me know!
I will close this now. Thanks for the suggestions
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question