Er or doctors office?

My husband has had a headache for more than 24 hours now. He took 4 bc powers throughout the day yesterday with no release and some advil last night that also did not help. He rarely gets headache but when he dose they only last a few hours and are helped by bc power. Last night he said he didn't feel good but he looked fine, about a min later I looked at him again he was pale white and pouring sweat. He couldnt sleep last night. I have been with him for 4 years he has NEVER called into work sick except for today and he only goes to a dr when I make him and spend a few days bugging him about it. He told me he wants to see dr today and wasn't getting outa bed till it was time to go to the dr. So this has me very worried. My question is... What type of dr would he see for this or should I take him to the ER?