The 40mm tank connector requires a hole between 53mm to 70mm. These are the extreme inside and outside measurements, so the hole should be within these measures.
This style of tank connector allows the pipe to be pushed all the way through the fitting; once the locking ring is tightened it will form a water tight seal. Perfect for standpipes.
The threaded part of this connector is 1 3/4"