Error in Insert Query

[Middlemarch]

CurrentDb.Execute ("INSERT INTO hList SELECT vLIst.* FROM vList WHERE vList.MyNum > = 288;")

I wanted all fields in vList from 288 would go into hList (which is a blank table of the same structure as vList)



But I'm getting Syntax error (missing operator) in query expression. What might be wrong please?

[ArviLaanemets]

Probably because you used alias to point at field, but you did'nt define this alias!
Try
"INSERT INTO hList SELECT * FROM vList Whe MyNum >= 288;"
Or to be on safe side
"INSERT INTO hList SELECT vlist.* FROM vList vlist Whe vlist.MyNum >= 288;"

[Micron]

IIRC, you're not supposed to enclose the sql statement or variable.
CurrentDb.Execute "INSERT INTO hList SELECT vLIst.* FROM vList WHERE vList.MyNum > = 288;"