Reading Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sc5502
    New Member
    • Jun 2014
    • 102

    Reading Excel

    I have never read an Excel file and populate a datagridview. Here is my code
    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
    Code:
     MyCommand.Fill(DataSet)
    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.
Working...