Turning your eyes and not looking as well as having someone dear to you holding your hand should all help. In addition they may be willing to give you a small shot of lidocane before setting an IV or giving you a shot. Its less than 1 cc (I think like 1/10th of a cc) and the needle is tiny, short and thin.
I well remember, I even had to look the other way while holding my babies for their innoculations, doctor would bring the needles in covered w/a towel as I would start gagging the minute I saw a needle.
My family doctor kept trying to convince me to give myself my own B12 shots. Yeah, right! When I finally (years later) agreed to try, his nurse emptied the syringe, left the room, and came back w/a syringe w/a LOT thinner, shorter needle for me to use to try to give my first shot myself.
They always seem to prefer to use a larger and longer needle that can be used for a variety of "drugs" of varying "thickness".
Once you've had a few severe pain and/or vomiting episodes relieved w/a shot of morphine and/or phenergan that should also help you get over the needle phobia. Your brain and eyes will recognize needles as RELIEF instead of pain.