0

I created web application, in this application there is a part of insert Large string (String having more than 10000 characters) values in to excel sheet using oledb query. i have tried the below code but i am getting

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." this error.

string con = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.xls;Extended Properties=Excel 8.0;";
            using (OleDbConnection connection = new OleDbConnection(con))
            {
                connection.Open();
                // string str = "bsdhjbdshjfbdhjsfsbjfsbfhjsfbjhbfjhbfjhsbhfshjfjfbjhfjshfjhsfjshfjdhsfjsjfdsjfj";
                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();
            }

so can any one suggest me how to insert more than 10000 character string value into Excel sheet using Oledb Query.

Mohan G
  • 1
  • 2

0 Answers0