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