vb.net為啥連接excel時出現“找不到可安裝的 ISAM”錯誤
vb.net為啥連接excel時出現“找不到可安裝的 ISAM”錯誤。原代碼如下:
'建立Connection对象的数据源连接字符串:
Dim connstring As String = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + Server.MapPath("xml/A31.xls") + ";Extended Properties=Excel 8.0"
Dim connection As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(connstring)
Dim adp As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter("Select * from [A31$]", connection)
Dim ds As System.Data.DataSet = New Data.DataSet
' connection.Open()
adp.Fill(ds, "Book1")
Me.GridView1.DataSource = ds.Tables("Book1").DefaultView
Me.GridView1.DataBind()
' connection.Close()