This worked for me:
OleDbConnection ExcelConnection = new OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\temp\excel_data_file.xls';Extended Properties=Excel 8.0;");
OleDbDataAdapter ExcelCommand = new OleDbDataAdapter("select * from [Tabelle1$]", ExcelConnection);
DataTable dtExcel = new DataTable("is_wuascht");
ExcelCommand.Fill(dtExcel);
Console.WriteLine("list of column names");
Console.WriteLine("column name: " + dtExcel.Columns[0].ColumnName);
Console.WriteLine("column name: " + dtExcel.Columns[1].ColumnName);
Console.WriteLine("row data");
foreach (DataRow dr in dtExcel.Rows)
{
Console.WriteLine("Row: " + dr[0].ToString() + ":" + dr[1].ToString());
}