There are two simple ways to remove the password from a PDF file, one of which works no matter what software you have.
To password protect a PDF in Adobe Acrobat Reader, you'll need the paid Pro version, which starts at $14.99 a month.
In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table in it. Now select Import. Choose the table from the list that appears and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results