string con = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Mohan.G\WorkTimeSheet\Test.xls;Extended Properties=Excel 8.0;"; using (OleDbConnection connection = new OleDbConnection(con)) { connection.Open(); string str ="bsdhjbfdggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggdfgdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddshjfbdhjsfsbjfsbfhjsfbjhbfjhbfjhsbhfshjfjfbjhfjshfjhsfjshfjdhsfjsjfdsjfjjglfgjlkjgoig/dfdfgflkdglkfgfjlkgkjldfglklfggjoitglklkfjdgoidjgldmgldgogloieewrlkrj/k.asuhdidkahdsdhisuahdiuhsikudhiusadhiusdhishdisiduhidhsihahudihiuhisahdiuhiai"; string sqlStquery = "Insert into [Sheet1$] ([ID],[Name]) Values ('" + 0 + "','" + str + "')"; OleDbDataAdapter dbadapter = new OleDbDataAdapter(sqlStquery, connection); dbadapter.SelectCommand.ExecuteNonQuery(); dbadapter.Dispose(); connection.Close(); connection.Dispose(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)