HELP!!!

Who here is ever had a hysterosalpingogram (where they inject dye into your fallopian tubes so they can see if they are open or closed)? I'm so nervous because I have one scheduled for next week. My doctor said it can be painful. Just trying to get some idea of what to expect?