ASP.NET

string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Salary.xls;Extended Properties=""Excel 8.0;HDR=YES;""";<br />
            OleDbConnection conn = new OleDbConnection(strConnection);<br />
            //conn.Open();<br />
            OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);<br />
            // command.Connection = conn;<br />
            // command.CommandType = CommandType.Text;<br />
            // command.CommandText = "SELECT * FROM [Sheet1]";<br />
            OleDbDataAdapter da = new OleDbDataAdapter(command);<br />
            DataTable dt = new DataTable();<br />
            conn.Open();<br />
            da.Fill(dt);<br />
            conn.Close();<br />
<br />
            //return dt;<br />
        }<br />
        catch (Exception ex)<br />
        {<br />
     Response.Write( ex.Message);<br />
            //return null;<br />
<br />
<br />
<br />
        }