Upgrade to Excel 2007. Prior versions were limited to 255 characters in a cell

Peter Richardson

" wrote:


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?