HSG test

Rose
Has anyone had an HSG test done? Was it painful? Scheduled for next Wednesday morning, not sure if I need to take the whole day off from work...