Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting data into next blank cell down in next sheet | Excel Worksheet Functions | |||
need help please inserting multiple rows based on cell value then copying to data sheet | Excel Worksheet Functions | |||
How to use vba for inserting data into a sheet that is acting as a template or form | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |