Hey charmedwitch.
When I had my wisdom teeth removed in February of this year, they put a small oxygen bulb type thing over my nose (just oxygen, at first) and then inserted an IV (I don't like needles, either, but I only felt a small pinch and then nothing at all). I heard one of the women say "O.k. the smell is going to change a little bit.." and I kinda remember going "Oka....." and that was it; I was out!
I was nervous, too, even though I'd actually already been knocked out once before, for wrist surgery. Before the oral surgery, I was pacing the office waiting room, but once I got back there it was way easy. I woke up in 45 minutes like I was waking up from a nap!
Have you gone in for your consultation, yet? If not, make sure you're honest with them about being nervous while you're there. If you've already gone, call them up and ask to speak to one of the assistants or the oral surgeon. I assure you, you aren't the first person to BE nervous and if they're good at what they do, they'll be able to suggest some things to help you with it (give you something medication wise ahead of time or thigns they do before hand so you don't notice the needles, etc.)