Note: In place of a knitting needle, you could use a...
plastic or metal rod or tube
...anything long enough to wind on that's rigid and will fit in the drill chuck. Here I used a size 9 needle. You could go larger or smaller as long as it seats properly in the chuck and spins without wobbling.