I am trying to extract a cell value from a spreadsheet. I can get it to work selecting the entire spreadsheet, but i only want to select the one cell. when I change the select statement from Select * from [Mgr$] to [Mgr$F9:G9] or just the G9 my reader returns false. any ideas?<BR><BR>here is my code:<BR><BR> Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR> "Data Source=C:databasesCodeasUgo132_121504_2.xls;" & _<BR> "Extended Properties=""Excel 8.0;"""<BR> conn1 = New OleDb.OleDbConnection(strConn)<BR> conn1.Open()<BR><BR><BR><BR> myCommand = New OleDb.OleDbCommand("SELECT * FROM [Mgr$G9:G9]", conn1)<BR> myReader = myCommand.ExecuteReader<BR> Dim strValue As String<BR> Do While myReader.Read<BR> If IsDBNull(myReader(0)) Then<BR><BR> Else<BR> strValue = myReader(0)<BR> End If<BR> <BR> Loop<BR>