Nah, acupuncture rarely hurts. If it does hurt, you could imagine the pain to be that of an ant bite. Points at the extremities might be more sensitive, but the sensation is usually brief.
Needle manipulations done by our TCM physicians might give you feelings of dull ache, tightness, tingling or radiating sensation at the site of manipulation.