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 ...