Hi,
i'm using this code to import data from an EXCEL file:

oleConn = new OleDbConnection(strConn);
oleConn.Open();

dtSchema = oleConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables , null);
DataRow fRow = dtSchema.Rows[0];
TheSheet = fRow["TABLE_NAME"].ToString();
TheSheet = TheSheet.Substring(0, TheSheet.Length - 1);
oleConn.Close();

if (!TheSheet.EndsWith("$")) TheSheet += "$";
OleDbDataAdapter myAdapter = new OleDbDataAdapter("SELECT * FROM [" +
TheSheet+ "]", strConn);
myAdapter.Fill(ds);


The problem occurs when the first sheet (DataRow fRow = dtSchema.Rows[0];)
is not the active one.

So my question is ... in the code above, how can i get the actie sheet
instead of the first one?