Importing PDF to Excel - some pages of PDF are missing

Copper Contributor

I am trying to import data from a PDF into Excel using the "get data" option.  When I do so, most of my data is there, but some of the data (actually, all the data on some of the pages of the PDF) is missing.  Is there a way to make sure ALL data from ALL pages import (or is there a way to find the data to include)?  As you can see below, all the tables are listed, but it skips about every other page of the pdf.  The first page of each table has a data set in it and the 2nd page has another table (that would equate to one subject/header with another cell of text).

JennifferAPMgrLou_0-1671024820054.png

 

0 Replies