I have never read an Excel file and populate a datagridview. Here is my 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
-
-
When the code is executed the
causes the Catch ex as Exception to display
System.Data.OleDb.OleDbException (0x80004005): Cannot update. Database object is read-only.
What am I doing wrong? Thanks in advance.
