Excel Spread sheet update RRS feed

  • Question

  • Hi,
     Iam trying to update a excel spread sheet from c#. One of the columns on my excel spread sheet with category as 'Custom" and format as "m/d/yyyy h:mm".
    My Update query is of the form

    UPDATE [TABL2$] SET RESULT = 'FAIL ' WHERE (col1 ='Circulation_Item_Typ') AND (col2='Closed') AND (col3 ='1/1/1900 2:00:00 AM')

    where the col3 has the format as mentioned above on the excel spread sheet. My code throws a exception  (Data type mismatch in criteria expression) . How do i do this update?

    Thanks in Advance.
    • Moved by Peter Ritchie Thursday, November 13, 2008 3:39 PM Not related to C# language syntax. (Moved from Visual C# Language to Off-Topic Posts (Do Not Post Here))
    Thursday, November 13, 2008 3:09 PM

All replies