vb.net - Inconsistent behavior when using OleDbDataAdapter with MS Excel -
i using ms excel 2010 sort of database store data records , manipulate them vb.net forms. i observing strange , inconsistent behavior: the data record populated insert command//insertcommand.executenonquery() api of vb.net the data record sometimes not modified update command//updatecommand.executenonquery() api of vb.net. however, api status success , returns number of affected rows 1 at other times, same piece of code able modify record during time of failure, if execute couple of sql commands manually (at microsoft query dialog in excel), , re-run vb.net code, records start getting updated! here's simple piece of code: ''''''''''''''''''''''' dim obj new cdatabaseconnection obj.dbconnect() dim strsql string strsql = "update [mytable$] set status = 'cancelled' id = 39" obj.dbrunupdatequery(strsql) obj.dbdisconnect()