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

​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.ConnectionSet 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 & “;”    .OpenEnd With — Sample example I found transfer-excel-data-from-ado-recordset Any guidance greatly appreciated  Read More

​