In the library at the college of winterhold is a spell book. use it to learn the spell and you can deplete a vein of ore in a few seconds.

Alt version by Slinx
here's a list of the changes:
 
made relevant perk alteration adept instead of destruction expert
added the sounds that magelight uses and the rock trap bouldernoises for when it's being cast instead of the original which was
silent
changed the description (cleaned up a typo and some phrasing)
changed name to Extract Ore
Changed Spellbook name and description to match
Changed Spell preview image in inventory to generic alteration preview from generic destruction preivew