Couldnt go through with the HSG test.

anyone else have this problem? I got my first pap done this summer and it was excruciating. I believe I have either Endo because I have a lot of symptoms of it or at least the tensing up issue. who knows. I was brave until he tried to put the speculum in and it was the worst pain I've ever felt. I said I can't do it and he acted annoyed, then I cried of pain and embarrassment. If I can't take a speculum how am I supposed to continue on with IUI, IVF, pregnancy and even give birth? It was a big let down today. I feel as though I've let down my husband who desperately wants a bio child. I really think I'm just too sensitive and maybe it isn't for me. Its heartbreaking. Anyone have similar experiences? I don't think there's a way to make it less painful. My husband and I can't even have sex without it hurting so we just don't. We don't even know if there is anything wrong with either of us yet.