Go buy some Emla cream from the chemist. Put it on 1-1.5 hours before the test and it'll numb the area, you won't feel a thing!
That's how I got through all needles during my last pregnancy.