I had a look at road mapping software - to drive came out at 511 miles, just 8½ hours each way.
I wouldn't recommend you do too many day return trips.
The school is Moncton Flight College
http://www.mfc.nb.ca/home.aspx but be advised that their JAA approval status is currently "expired" (due change of management on the JAA programme) with a revalidation scheduled for April 18th (or soon after).