To hit a close range missile flying towards you, you essentially have create a solid wall of bullets for it to collide into. You won't be able to accurately hit it and your best bet is essentially spray and pray.
The Phalanx Close-In Weapon System essentially does this by predicting a missle's flight path and shooting up to 4500 rounds per minute in front of it.