Thanks for the reply i will give this a go as soon as i find something to poke down the hole, what sort of length am i looking at? and where is the other end of the drain pipe where it should discharge the water?
Well...from the top to the rocker panel...if you can get it to pass completely through. But usually no more than a 2 or 3 feet are needed. I use a steel cable that is 3/32" dia. and I wrapped a tiny bit of Gorilla, duct, tape around the end of it. An air compressor can, in some cases, make it worse as there is often a bit of hose that connects the moonroof pan to a tube in the pillar...if plugged, the air pressure can cause the hose to dislodge from the tube if the air nozzle is pressed into the outlet hole too hard.
The water should drain out at the front of the rocker panel.