Cochrane reviews show that acupuncture works for some types of pain: http://www.ncbi.nlm.nih.gov/pubmed/21359919
(It's not mentioned in the abstract I linked, but searching Cochrane's site shows that they look at studies comparing acupuncture to a "fake" acupuncture, which is presumably putting needles randomly.)