Excel VBA write to Sharepoint list - error "Could not find installable ISAM"

Hi all,

I am trying to write to a Sharepoint list from Excel VBA, I've been attempting to connect as an ADODB

When I attempt to open the Connection I receive the error "Could not find installable ISAM", would anyone have any guidance on what I am doing wrong, here is a snippet of the code.

(How do I know if I am using the correct settings string values?)

--

Dim sListID$, sPathDB$

Set cnt = New ADODB.Connection

Set rst = New ADODB.Recordset

mySQL = "SELECT * FROM " & sListID & ";"

With cnt

    .ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;" _

                                      & "DATABASE=" & sPathDB & ";LIST=" & sListID & ";"

End With

With cnt

    .Provider = "Microsoft.ACE.OLEDB.12.0"

    .ConnectionString = "Data Source=" sPathDB & ";LIST=" & sListID & ";"

    .Open

End With

--

Sample example I found transfer-excel-data-from-ado-recordset

Any guidance greatly appreciated