实验貌似没法用Delete,insert,Update语句？语句在SQL的查询分析器里可以正确通过检验，保证没有语法错误

比如Delete [Easy] where [Point] < 60
这样简单的东西是不可能错的啦，但是执行失败

请问是不是没法这样操作的，只能用Select语句

Delete [Easy] where [Point] < 60
可以这样用吗?

不是可以通过OldDb对Excel像操作数据库一样操作吗？这句话没SQL语法错误啊！

现在查，添，改，都没问题了，就差删了
提示是“操作符丢失”

不好意思,看成SQL了.你把代码贴上来让大家研究一下.

class ExcelConnection
{
public string ExcelConnString;
public OleDbConnection ExcelOldDbConn = new OleDbConnection();

public ExcelConnection(string ExcelFileName)
{
ExcelConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFileName + ";Extended Properties=Excel 8.0";
ExcelOldDbConn.ConnectionString = ExcelConnString;
}

public void ExcelOpen()
{
ExcelOldDbConn.Open();
}

public void ExcelClose()
{
ExcelOldDbConn.Close();
}

public DataSet ExcelReadDS(string Range, string SheetName, string Condition)
{
string ExcelSelectStr = "SELECT " + Range + " FROM " + SheetName + " " + Condition; //查询语句
OleDbDataAdapter ExcelSelectDA = new OleDbDataAdapter(ExcelSelectStr, ExcelOldDbConn); //执行查询
DataSet ExcelDS = new DataSet();
ExcelSelectDA.Fill(ExcelDS); //填充数据
ExcelSelectDA.Dispose();
return ExcelDS;
}

public OleDbDataReader ExcelReadDR(string Range, string SheetName, string Condition)
{
string ExcelSelectStr = "SELECT " + Range + " FROM " + SheetName + " " + Condition;
OleDbCommand ExcelSelectCmd = new OleDbCommand(ExcelSelectStr, ExcelOldDbConn);
OleDbDataReader ExcelDR = ExcelSelectCmd.ExecuteReader();
return ExcelDR;
}

public void ExcelInsert(string SheetName, string Range, string Value, string Condition)
{
string ExcelInsertStr = "INSERT INTO " + SheetName + " ( " + Range + " ) VALUES ( " + Value + " ) " + Condition;
OleDbCommand ExcelInsertCmd = new OleDbCommand(ExcelInsertStr, ExcelOldDbConn);
ExcelInsertCmd.ExecuteNonQuery();
ExcelInsertCmd.Dispose();
}

public void ExcelUpdate(string SheetName, string UpdateValues, string Condition)
{
string ExcelUpdateStr = "UPDATE " + SheetName + " " + UpdateValues + " " + Condition;
OleDbCommand ExcelUpdateCmd = new OleDbCommand(ExcelUpdateStr, ExcelOldDbConn);
ExcelUpdateCmd.ExecuteNonQuery();
ExcelUpdateCmd.Dispose();
}

public void ExcelDelete(string SheetName, string Condition)
{
string ExcelDeleteStr = "Delete " + SheetName + " " + Condition;
OleDbCommand ExcelDeleteCmd = new OleDbCommand(ExcelDeleteStr, ExcelOldDbConn);
ExcelDeleteCmd.ExecuteNonQuery();
ExcelDeleteCmd.Dispose();
}
}

这是一个我写的Excel文件操作类的全部代码，查，添，改，都没问题了，但是删会报错
请指教删的问题
贴在这里，也算开源了～

看不出哪里出错了~~~

目录写保护和权限都没问题，还真不知道哪错了呃……