string strExcelConn;
     strExcelConn= "Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source=C:\\Documents and Settings\\Deb\\Desktop\\New XML work\\0UIIAP0010_2009-02_RENEWAL_REPORT (1).xls;" +
        "Extended Properties=Excel 8.0;";
        //use the $ after the object you reference in the Excel sheet
        OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [TML 2009-02$]", strExcelConn);

        DataSet myDSet = new DataSet();
        myCommand.Fill(myDSet , "ExcelTableInfo");
        DataGrid1.DataSource = myDSet .Tables["ExcelTableInfo"].DefaultView;
        DataGrid1.DataBind();