StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCould not find installable ISAM in excel 2007 vba
text
Body
copied!<p>i want to try connecting excel to excel using ado connection and vba. but the problem is it give's an error could not find installable ISAM. i tried to look at other solution but same issue will return. may be there's a activex control that im missing? here's my code</p> <pre><code>Dim cN As ADODB.Connection '* Connection String Dim RS As ADODB.Recordset '* Record Set Dim sQuery As String '* Query String Dim i1 As Long Dim lMaxRow As Long '* Last Row in the Sheet Dim iRevCol As Integer '* Dim i3 As Integer Set cN = New ADODB.Connection cN.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\PC\Desktop\Excel Programming\PlayerDatabase.xlsm;Readonly=False;Extended Properties=Excel 12.0;;HDR=yes;Persist Security Info=False" cN.ConnectionTimeout = 40 cN.Open Set RS = New ADODB.Recordset lMaxRow = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row sQuery = "Select * From [Player$]" RS.ActiveConnection = cN RS.Source = sQuery RS.Open If RS.EOF = True And RS.BOF = True Then MsgBox ("End of File") End If If RS.State <> adStateClosed Then RS.Close End If If Not RS Is Nothing Then Set RS = Nothing If Not cN Is Nothing Then Set cN = Nothing </code></pre> <p><strong>UPDATE:</strong></p> <p>now i change my connectionstring to this</p> <pre><code>cN.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\PC\Desktop\Excel Programming\PlayerDatabase.xlsm;Extended Properties='Excel 12.0 Macro;HDR=YES'" </code></pre> <p>but it gives me error Cannot update. <strong>Database or object is readonly.</strong></p> <p>when i put readonly=false</p> <pre><code>cN.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\PC\Desktop\Excel Programming\PlayerDatabase.xlsm;ReadOnly=false;Extended Properties='Excel 12.0 Macro;HDR=YES'" </code></pre> <p>it will give an error as could not find installable ISAM :(</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload