Can we get data from table feature of Excel 2007 / 2010?
Select * from Table1 or Table 6,
instead of select * from [Sheet1$]
An example for Excel 2007
You should create in your own Excel File in:
Formulas -> Name manager (I don't know exactly that name in english), selecting your table, and bind a name for that, for example, myTable.
In your application, you select again the sheet:
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [sheet$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objDataset1 = new DataSet();
But here you can select a table: