Getting the first sheet from an Excel document regardless of sheet name with OleDb

Question

I have users that name their sheets all sorts of crazy things, but I want to be able to get the first sheet of the Excel document regardless of what it is named.

I currently use:

OleDbDataAdapter adapter = new OleDbDataAdapter( "SELECT * FROM [sheetName$]", connString); 

How would I go about getting the first sheet no matter what it is named?

Thank you.

Answer 1

ended up using this:

using (OleDbConnection conn = new OleDbConnection(connString)) {     conn.Open();     dtSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });     Sheet1= dtSchema.Rows[0].Field<string>("TABLE_NAME"); }