string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + FullFileName + ";Extended Properties=Excel 8.0;";****
****
sqlOLDB = "insert into [Sheet1$] values('" + "2009-12-01 15:31:21" + "','" + "2009-12-01 15:31:21" + "','" + "" + "','" + NAME+ "')";xls文件中有前两列是日期格式如: 2009-12-01 15:31:21. 但在C#中插入出现 Data type mismatch in criteria expression 是什么问题？
****
sqlOLDB = "insert into [Sheet1$] values('" + "2009-12-01 15:31:21" + "','" + "2009-12-01 15:31:21" + "','" + "" + "','" + NAME+ "')";xls文件中有前两列是日期格式如: 2009-12-01 15:31:21. 但在C#中插入出现 Data type mismatch in criteria expression 是什么问题？
即"#2009-12-01 15:31:21#"