Caffeine keeps you from sleeping, but it does not make you awake. At least that is how I feel.

Also, I vastly prefer tea over coffee. Usually green/white tea, or mate tea (even more caffeine) or some herbal stuff.