Hi there, I don't fancy myself an expert on migraines at all, but i know a little since mine came on the scene seriously last winter and I got a very good headache specialist.
First of all, yes migraines can last for two weeks. I had one last winter that lasted thirteen days and I thought I was going to shoot myself. A lot of your symptoms sound like migraines, i.e. the location of your pain behind your eyes and at your temples, the sensitivity to light and sound, etc. however not all of them do. Because of your extreme pain I would go see a doctor immediately, you don't need to be in this kind of pain. The sudden onset doesn't sound like the way my migraines come on, it's more subtle. You could very well have a migraine, but it could be something more serious and I would get it checked out if I were you. If you don't have access to a good physician who will be able to run tests if necessary then you may want to go into the ER, generally these docs are notorious for not knowing enough about headaches but at least they should be able to check you out for more serious problems.
It may in fact "just" be migraines...there are a lot of things that go along with them, and YES, they can last for weeks at a time.
Eye pain, neck stiffness, GERD type symptoms and even fibromyalgia can all be common things in migraineurs.
I am glad you went to the ER and have a specialist appt scheduled. Just make sure the doc's take you seriously and understand the impact this is having on your life....I have found often with migraineurs that doctors do not treat us properly because they think "it's just a headache"
I hope you stick around...Welcome to the Migraine/Headache family
One of the best specialist that I know would mostly do you good, is an Osteopath. I would suggest that you make an appointment with one.
Until you see the Osteopath, do this acupressure technique, as needed, which I am giving you now as follow: " use you thumb and index finger of your right hand and place your thumb between your index bone and thumb bone, on top of your hand, where they join in you hand and your index finger opposite your thumb inside your left hand. On the soft tissue between both thumb and index. Do not dig in with your thumb and index. Instead, use both pads and apply pressure with your thumb on top and equalize it with your index finger underneath. Keep this pressure on till your headache is gone. Once you have done this to your left hand, you could do it to your right hand too. Depending on how long you had your Headache / Migraine, it will take up to 15 minutes per hand. You could do 10 min. the left hand and 10 min. your right hand ".