CODEWITHSUNDEEP
vb.netexcel
ken
ken

Reputation: 399

error when trying to read from excel in vb

I get this exception "could not find installable isam" when trying to read from an excel file in vb. I tried google and the most I get refers to a problem with my connection but I don't know how to fix that. Here is my connection string 

Dim MyConnection As System.Data.OleDb.OleDbConnection
MyConnection = New System.Data.OleDb.OleDbConnection _
        ("Provider=Microsoft.Jet.Oledb.4.0; Data Source='" & Application.StartupPath & "\kk.xls'; Extended Properties=Excel 9.0;")

Upvotes: 1

Views: 316

Answers (1)

Doug Glancy
Doug Glancy

Reputation: 27478

Try it without the single-quotes, and change to Extended Properties=Excel 8.0.

Upvotes: 1

Related Questions