PDF into Excel or Access
Results 1 to 4 of 4

Thread: PDF into Excel or Access
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2005
    Posts
    444
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default PDF into Excel or Access

    I have a list of addresses and other stuff in a PDF format that I need to convert to something that can import into Excel or Access. The list is proprietary so I cannot use an on line utility. Does anyone have any suggestions as to how this might be accomplished?
    I can do a modicum of VBA for Excell, but the format of the PDF file is unknown to me.
    Thank you for your time
    Last edited by bkelly; Aug 4th, 2019 at 11:57 PM.
    Thank you,
    Bryan Kelly

    We need to know what a dragon is
    before we study its anatomy.
    (Bryan Kelly, 2010)

  2. #2
    Board Regular
    Join Date
    Jun 2011
    Posts
    1,413
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: PDF into Excel or Access

    If the PDF file contains scanned images, you need an OCR program to convert images to text. Adobe Acrobat (not the free Reader) can do it.

    If the PDF file originated from Excel or Word (save as PDF), then, you can save the PDF as a Word or Excel document (I tried it using Adobe Acrobat, not sure whether Adobe Acrobat Reader could do it.)
    Excel 2010, Windows 10

  3. #3
    Board Regular
    Join Date
    Jan 2005
    Posts
    444
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: PDF into Excel or Access

    Quote Originally Posted by yky View Post
    If the PDF file contains scanned images, you need an OCR program to convert images to text. Adobe Acrobat (not the free Reader) can do it.

    If the PDF file originated from Excel or Word (save as PDF), then, you can save the PDF as a Word or Excel document (I tried it using Adobe Acrobat, not sure whether Adobe Acrobat Reader could do it.)
    I should have said more. It does have text in that I can use the mouse to select text and copy paste to another file. When I try to do the export from PDF I am linked to an advertisement that wants a monthly fee for that ability.

    I remember from the past that sometimes I would run a search over entire files and not find the text I was looking for. That led me to conclude that PDF does not use standard text codes. Maybe I was looking at a picture based PDF rather than a text based one.

    Would VBA for Excel or Access be able to pick out the values between A and Z, a and z, 0 and 9, etc, and be able to write a text file of those hots characters?
    Thank you,
    Bryan Kelly

    We need to know what a dragon is
    before we study its anatomy.
    (Bryan Kelly, 2010)

  4. #4
    Board Regular
    Join Date
    Jun 2011
    Posts
    1,413
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: PDF into Excel or Access

    Try the method in this article. I didn't try it. If it works, please post back so other people can benefit from it.

    https://myengineeringworld.net/2012/...-pdf-file.html
    Excel 2010, Windows 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •