Through board connector
If you don't need the connectors to be 100% flush with the board surface, have a look at the PCB socket range by Harwin.



There's also a range produced by Mill-Max, but I've not had experience with them. I believe Digikey is their main distributor.



Note that theMill-Max sockets are meant to be pressed in, while Harwin sockets are soldered.