private void btnImportExcelToGrid_Click(object sender,
System.EventArgs e)
{
	String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
				"Data Source=C:\\Book2.xls;" +
				"Extended Properties=Excel 8.0;";

	DataSet ds = new DataSet();

	//You must use the $ after the object
	//you reference in the spreadsheet
	OleDbDataAdapter da = new OleDbDataAdapter
			("SELECT * FROM [Sheet1$]", strConn);

	//da.TableMappings.Add("Table", "ExcelTest");

	da.Fill(ds);
	DataGrid2.DataSource = ds.Tables[0].DefaultView;
	DataGrid2.DataBind();
}