Couldn't find installable ISAM

Question

Hi folks,

Please help to solve below indicated problem regarding sharepoint and excel connection.

I have VBA code where before I have downloaded list data from sharepoint to excel. Recently my company updated Office from 2016 to 2021. Then when I executed VBA code Error appears.

Couldn't find installable ISAM - image attached. When I debug error ".Open" line highlighted.

Sub PlannedBudget()

Dim cnt As ADODB.Connection
Dim rst As ADODB.Recordset
Dim mySQL As String

'set connection
Set cnt = New ADODB.Connection
Set rst = New ADODB.Recordset

'mySQL = "SELECT * FROM [PlannBudget] where [BudgetYear] > '2021';"

'open connection
With cnt
.ConnectionString = _
"Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=https://aaaaaa-bb.ccccc.eeeee/gggggg-eeeeee/;LIST={QQQQQ-AAAAA-ZZZZZ-1111-12334567890};"
.Open
End With

'rst!AmountLCY = Workbooks("Request - 2021.xlsb").Sheets("test").Range("P2")  
 
Sheets("Data2").Cells(2, 1).CopyFromRecordset rst  

End If