I am importing a number of PDF documents (bank statements - 3-6 pages in each document) into Excel. I have merged the PDF documents into one but only the first page imports using Power Query. I have also separated each document into separate pages and used the Get Data > From File > From Folder option also with all PDFs in separate pages. Thought this was working, but notice the last number of each records are missing from PQ and Excel. Any suggestions what I could try?
Hi Patrcia,
It's difficult to troubleshoot without seeing the query and files. It's particularly odd that some data comes in but not all.
I wonder if the technique described in this post will work for you: https://www.myonlinetraininghub.com/excel-forum/power-query/multiple-pdfs-with-multiple-pages
Mynda
I have been playing about with various options and when I select the sheet option, the data appears, but not Table.
At the Navigator dialog box are you able to see the tables and select them by checking the box for 'select multiple items' and then checking the box for the tables you want?
See screenshot attached.
Have used that on a merged version of the PDFs, but only a couple of columns of data is being imported from a couple of tables. I am using Get Data > from File > PDF.
When I have all 12 separate PDFs (3-6 pages in each) in a folder and use the from Folder option - it just brings in the first page of each PDF.
I have then separated all PDFs into separate pages and use the from Folder option - It brings in most of the data, except the last few rows of each page.
I'd have to see the PDFs and your query to troubleshoot as I can't reproduce that issue. If the data is sensitive, you can email it to me website at MyOnlineTrainingHub.com
Thanks. Much appreciated. Have just emailed website with some attachments.
