Has anyone had a Hysterosalpingography?

I am due for a Hysterosalpingography (HSG) exam next week and I am really worried about it. How painful is it? My doctor has only prescribed an anti biotic to treat possible infection but she hasn't advised me to take pain killer. I have heard it is very painful and uncomfortable.