SQL

削除

 strSQL = "DELETE * FROM t_Test" & i
 DoCmd.RunSQL strSQL

更新

 strSQL = "UPDATE t_Test" & i & " set myNo = " & i '"_set スペースに注意
 DoCmd.RunSQL strSQL