Twice in fact, in 63 and 67. His motivations, which he explained at length in a press conference that’s easy to find online were that the U.K. was only interested in a strictly limited free trade union, and wanted an extremely bespoke deal, excluding farming etc.
That never really changed, although Britain eventually gave up most of these conditions, when they finally joined.