Expand|Select|Wrap|Line Numbers
- 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
Expand|Select|Wrap|Line Numbers
- MyCommand.Fill(DataSet)
System.Data.OleDb.OleDbException (0x80004005): Cannot update. Database object is read-only.
What am I doing wrong? Thanks in advance.