string strCon = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excel_path + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1'";  
OleDbConnection myConn = new OleDbConnection(strCon);  
string strCom = "SELECT * FROM [Part$A7:AK] where [Part No]=10506";  
myConn.Open();  
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);  
DataSet myDataSet = new DataSet();  
myCommand.Fill(myDataSet, "Part");  
myConn.Close();  


//csharp/6148