h1!
I need to update data in *.xls file but I can't update because
I get exception : "Data type mismatch in criteria expression."
DataTable table = myDataSet.Tables[0];
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Mode=ReadWrite;Extended Properties='Excel 8.0;IMEX=0;HDR=YES;'";
OleDbConnection conn = new OleDbConnection(sConnectionString);
string cellAsColumn = "[Form ID]";
int i = 0;
conn.Open();
foreach (DataRow row in table.Rows)
{
if (!row["FormID"].ToString().StartsWith("form"))
{
...
Go to the complete details ...