Transition from coherent mesoscopic single-particle transport to Josephson proximity current