I am using the following SQL command in C# to fill a table from an Excel file.

string strSQL = "Select * FROM [Sheet1$F:G]";
daExcel = new System.Data.OleDb.OleDbDataAdapter(strSQL, urlconn);
table = new DataTable();
int ret = daExcel.Fill(table);

This works fine but I can't figure out how to use the WHERE statement for
selective processing. For example, if I use "Select * FROM [Sheet1$F:G]
WHERE [Sheet1$F] ' '", if get an error saying that there is a missing
value. Does anyone know how to use a WHERE statement when accessing an Excel
file?