prog. gives an error message that "Could not find installable ISAM".
Sub totals()
Dim cn As Object, rs As Object
Set cn = CreateObject("ADODB.Connection")
cn.Open _
"Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & ThisWorkbook.FullName & _
"Extended Properties=""Excel 12.0;HDR=YES"";"
Set rs = cn.Execute( _
"select distinct isim, sum(başvuru), sum(başarı) " & _
"from [Sayfa1$] " & _
"group by isim")
With Sheets("zeki")
.[a2:c65536].ClearContents
.[a2].CopyFromRecordset rs
End With
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
Bookmarks