This is really odd now.
Here's the test file I've been importing into Access 2016:
PAF_URN,Town,Postcode,Latitude,Longitude,Coordinate_Level
9941,ABERDEEN,AB10 7HJ,57.12534,-2.121958,Address
9942,ABERDEEN,AB10 7HJ,57.12569,-2.121909,Address
9943,ABERDEEN,AB10 7HJ,57.1257,-2.121728,Address...