Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Power Query Does Not Import Multiple PDF Pages
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Jun 2014
    Posts
    1,062
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Does Not Import Multiple PDF Pages

    Yeah, I just want to combine all table objects from PDFs from a folder. The columns of the tables is in the Contents column which when I expand only shows the records of the first table object of each PDF and is missing the rest of the tables. Only workaround I see is if I connect via "PDF" data source instead of from "Folder."
    Last edited by legalhustler; Oct 15th, 2019 at 11:24 PM.

  2. #12
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,027
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query Does Not Import Multiple PDF Pages

    try this way:

    Folder
    Load
    on the left click Data icon
    Edit Queries
    Remove rows
    right click Binary (column content)
    Drill down
    Column Data
    Expand columns

    because I don't have many files I did it for two files (one removed) second with 12 pages

    Last edited by sandy666; Oct 15th, 2019 at 11:44 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  3. #13
    Board Regular
    Join Date
    Jun 2014
    Posts
    1,062
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Does Not Import Multiple PDF Pages

    When I right click and Drill Down the Content column it creates a List in one column and I can drill down any of the Binary and expand the table objects, but I can't seem to drill down all of Binary at once so all the fields from each PDF are combined. Hope I'm articulating it so that it makes sense.
    Last edited by legalhustler; Oct 16th, 2019 at 12:05 AM.

  4. #14
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,027
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query Does Not Import Multiple PDF Pages

    my fault

    right click on the first binary - add as new query then dbl click on the file icon
    back to the top
    right click on the second binary - add as new query then dbl click on the file icon
    and so on...
    select column Data (with Tables) and expand in each query
    now you will have a few queries which can be merged/appended

    easier will be if you merge these pdfs with Adobe Acrobat and import data from single pdf file
    Last edited by sandy666; Oct 16th, 2019 at 12:23 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  5. #15
    Board Regular
    Join Date
    Jun 2014
    Posts
    1,062
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Does Not Import Multiple PDF Pages

    I have 235 PDFs, manually adding as new query will take too much time. That's a great idea about merging the PDFs with Adobe Acrobat (which I have). Let's see how it turns. Stay tuned. Thanks!

  6. #16
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,027
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query Does Not Import Multiple PDF Pages

    You are welcome

    Impatient person

    have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

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
  •