请教大虾:
For i = 0 To 999
strSQL = "INSERT INTO Students(Name,Score) VALUES(" + Chr(39) + Name(i) + Chr(39) + "," + Chr(39) + Score(i) + Chr(39) + ")"
con.Execute strSQL
Next上面代码执行后发现,Access 2000里的记录次序和原来的数组数据次序有一点差别,如何解决这问题,请教
For i = 0 To 999
strSQL = "INSERT INTO Students(Name,Score) VALUES(" + Chr(39) + Name(i) + Chr(39) + "," + Chr(39) + Score(i) + Chr(39) + ")"
con.Execute strSQL
Next上面代码执行后发现,Access 2000里的记录次序和原来的数组数据次序有一点差别,如何解决这问题,请教
strSQL = "INSERT INTO Students(Name,Score) VALUES('" + Name(i) + "'," + Score(i) + ")"
con.Execute strSQL
Next 查看时用下面这个
strSQL = "select * from Students order by score asc"
con.Execute strSQL