HSG? Who has had one? Painful?

Renee

Who here has had an HSG test done? I'm scheduled to have one and have heard such horror stories!! How was it?