I am very new to C# and .NET Framework. I want to know how to Read Microsoft Excel Cells using OleDb Command. For example I want to read from Sheet 1. I want to read the value of cell of Column A where Cell value of Column B is 5. The code I am using is as follows string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\test.xls; Extended Properties=Excel 8.0"; //Create the connection System.Data.OleDb.OleDbConnection ExcelConnection =new System.Data.OleDb.OleDbConnection(ConnectionString); ExcelConnection.Open(); //create a string for the query string ExcelQuery; //Sheet1 is the sheet name //create the query: //read column with heading A from the Excel file ExcelQuery ="SELECT A FROM [Sheet1$] WHERE B=5"; // from Sheet1"; //use "Select * ... " to select the entire sheet //create the command System.Data.OleDb.OleDbCommand ExcelCommand = new System.Data.OleDb.OleDbCommand(ExcelQuery, ExcelConnection); //Open the connection //ExcelConnection.Open(); //Create a reader System.Data.OleDb.OleDbDataReader ExcelReader; ExcelReader = ExcelCommand.ExecuteReader(); //For each row after the first while (ExcelReader.Read()) { Console.WriteLine((ExcelReader.GetValue(0)).ToString()); } ExcelConnection.Close(); But the problem with this code doesnot execute the line ExcelReader =ExcelCommand.ExecuteReader();