I haven't tried acupuncture, but went to a chiropractor who worked on pressure points/trigger points that seemed to provide some good relief.
I found a book at Borders Books called "The Trigger Point Therapy Workbook" by Claire Davies that is very good (large paperback).
There's an entire chapter on head and neck pain, but other pages that relate via the index.
This book has brought me relief for shoulder pain, TMJ pain, and headaches, but it covers the whole body.
Parts might get a little technical with names of muscles... but it's easy enough to follow to get some relief. It shows you were to find the trigger point, and also shows where you might be feeling related pain. I also used it for sinus pain relief.