If it's anything like a transvaginal ultrasound, they lube up a wand-shaped device and insert it down there. I normally find pap smears to be uncomfortable, but had no problem with the two transvaginal ultrasounds I had during pregnancy.
Hope you get the results you're looking for!