View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cvsudheer@gmail.com is offline
external usenet poster
 
Posts: 1
Default Pro grammatically Inserting data to Excel Sheet


Hi All,
I am inserting data to an Excel sheet pro grammatically.
I use the following udpate command:

da.UpdateCommand = new OleDbCommand(@"UPDATE [Sheet1$] SET
[Description (QA)] = ? , [R&D Comments (Dev/Analysts)] = ? WHERE
[Defect ID] = ?", conn);
da.UpdateCommand.Parameters.Add("@Description (QA)",
OleDbType.VarChar, 255, "Description (QA)");
da.UpdateCommand.Parameters.Add("@R&D Comments (Dev/Analysts)",
OleDbType.VarChar, 255, "R&D Comments (Dev/Analysts)");

I cant use a value 255.
Is there anyway to increase the limit?