Hi Sian
I had mine just before Christmas. I, like you, was a bit anxious after reading all the scare stories but mine didn't hurt. The beginning feels just like a smear (its that speculum thing). I didn't feel the tube go in, nor the dye. The only bit that felt a bit odd was when he asked some bod in the corner to blow the balloon up, but that wasn't painful- just odd. It was over in about a minute. I took Ibuprofen beforehand but needed nothing after. I had odd twinges about 3-4 days after but nothing much. Personally I had to wait for the results in the post, but every hospital seems to be different.
I was worried that the fact that mine was quick and painless might have indicated a problem, but it turned out clear both sides.
Don't worry, you'll be fine. I was worried too- I expect thats quite normal. I just prepared myself by thinking "Oh well, its not going to hurt as much as childbirth will so here goes". Seems to have worked for me :lol: