how to transfer data from excel to sql server table

hey thanks everyone, i figured a way out..for all those who get in a situation like this..here is the code.. string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + //"Data Source=" + File1.Value + ";" + "Data Source=C:\\Book1.xls;" + "Extended Properties=Excel 8.0;"; //You must use the $ after the object you reference in the spreadsheet OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); DataSet myDataSet = new DataSet(); myCommand.TableMappings.Add("Table" , "ExcelInfo"); myCommand.Fill(myDataSet); DataGrid1.DataSource = myDataSet.Tables[0].DefaultView; DataGrid1.DataBind(); SqlConnection conn = new SqlConnection(ConnStr); SqlCommand cmdinsert = new SqlCommand ("sp_insertbooks",conn); cmdinsert.CommandType = CommandType.StoredProcedure; try { conn.Open(); foreach( DataRow dr in myDataSet.Tables[0].Rows) { SqlParameter param = new SqlParameter("@bookid", SqlDbType.Int,4); param.Value = dr[0]; cmdinsert.Parameters.Add(param); SqlParameter param1 = new SqlParameter("@bookname", SqlDbType.VarChar,255); param1.Value = dr[1]; cmdinsert.Parameters.Add(param1); SqlParameter param2 = new SqlParameter("@bookdesc", SqlDbType.VarChar,255); param2.Value = dr[2]; cmdinsert.Parameters.Add(param2); cmdinsert.ExecuteNonQuery(); cmdinsert.Parameters.Remove(param); cmdinsert.Parameters.Remove(param1); cmdinsert.Parameters.Remove(param2); } Response.Write("Record Added
"); } catch (Exception ex) { Response.Write(ex.ToString()); } finally { cmdinsert.Connection.Close(); } And here is the stored proc for insertion.. create proc dbo.sp_insertbooks @bookid int, @bookname varchar(255), @bookdesc varchar(255) as SET NOCOUNT ON insert into Book values(@bookid, @bookname,@bookdesc)