用Excel做DB，連接字符串如下：ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TEST.xls;Extended Properties='Excel 8.0;HDR=YES;'";用OleDbDataAdapter對Excel進行數據插入，代碼如下：OleDbConnection oleConn = new OleDbConnection(ConnectionString);oleConn.Open();OleDbCommand oleCmd = new OleDbCommand("select * from " + tableName, oleConn);OleDbDataAdapter da = new OleDbDataAdapter(oleCmd);ds1 = new DataSet();da.Fill(ds1, "[sheet1$]");ds1.Tables[tableName].PrimaryKey = new DataColumn[] { ds1.Tables[tableName].Columns[0] };DataRow row = ds1.Tables["[sheet1$]"].NewRow();row[0] = 1;row[1] = "Hello";OleDbCommandBuilder myCommandBuilder = new OleDbCommandBuilder(da);      da.InsertCommand = myCommandBuilder.GetInsertCommand();da.Update(ds1,tableName); //提示“Syntax error in INSERT INTO statement” 請教大俠，問題到底出在哪里，郁悶了許久，google了也沒找出問題。ps:也設了主鍵，應該不是主鍵問題