How to import data from Excel file using C#

[admin]

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();
}

[admin]

For Excel 2007 you can use the following connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=C:\\Book2.xls;" +
"Extended Properties=Excel 12.0;"

[admin]

by the way you needn't to have Excel instauled on the server machine only you can download the driver from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554f536-8c28-4598-9b72-ef94e038c891&DisplayLang=en
 

[admin]

Important note: if you are selecting data for a specific date you can use the following:
"SELECT * FROM [Sheet1$] where datecol=#3/15/2009#"
don't try to use the single quotes " ' ".