I have never read an Excel file and populate a datagridview. Here is my code
When the code is executed the
causes the Catch ex as Exception to display
System.Data.Ole Db.OleDbExcepti on (0x80004005): Cannot update. Database object is read-only.
What am I doing wrong? Thanks in advance.
Code:
Try
Dim path As String = "C:\\Users\\test\\Desktop\\Event_Logs\\system.xlxs"
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DataSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection _
("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & path & ";Extended Properties=Excel 12.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("Select * from [system$]", MyConnection)
DataSet = New System.Data.DataSet
MyCommand.Fill(DataSet)
DataGridView1.DataSource = DataSet.Tables(0)
MyConnection.Close()
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
Code:
MyCommand.Fill(DataSet)
System.Data.Ole Db.OleDbExcepti on (0x80004005): Cannot update. Database object is read-only.
What am I doing wrong? Thanks in advance.