Try Meguiars three-step process.

You should be able to get rid of them with step 2, the polish. Then finish off with step 3, the wax - to protect it against further water spots.

If they're really stubborn, you could try step 1, the cleaner.

------------------
01 SE 6cyl 5spd Solar Yellow
_________________________
Modified 2001 SE 6cyl 5spd 4x4 Solar Yellow
-=( Another useless post, brought to you by da 'Phreak! )=-