Yup, I've done it. The trick is, you have to quick get the needle back through and out of the nail before the shock wears off - otherwise, it hurts even more to pull it through!
There's at least one more thread here on this quilting-related injury. Some people hit the bone - and that was really bad...