Data transmission in the millimetre wave (mm-wave: 30 – 100 GHz), sub-terahertz (sub-THz: 100 GHz – 300 GHz) and THz (300 GHz – 3 THz) frequency bands will be a key aspect of the 5th generation (5G) and 6th generation (6G) wireless systems in order to achieve more than 1 Gb/s and 10 Gb/s per user data rates, respectively. An efficient mm-wave/THz signal generation technique and a spectrally efficient fronthaul distribution network are two important elements to fulfil the demand for such high data rates. This research thesis focuses on the optical heterodyne analogue radio-over-fibre link to simultaneously generate and distribute the mm-wave signals to the increased number of remote antenna sites. The choice of the optical fronthaul scheme should facilitate the centralization of resources and simplify the remote antenna site. The first part of the thesis focuses on analysing the capacity of spectrally efficient analogue intermediate frequency over fibre fronthaul scheme by simultaneously transmitting multiple 5G signals over a directly modulated 25 km fibre link influenced by multiple impairments. The analogue RoF link is then combined with an optical heterodyne technique to demonstrate the generation and distribution of the mm-wave signals. The performance of a such fibre-wireless system is majorly limited by the frequency drift and phase offset between the optical carriers, obtained from the use of free running lasers, and techniques that ease these restrictions with minimal additional complexity are of paramount importance for wide deployment. Two innovative solutions are demonstrated, in the second part, to compensate for the effect of laser frequency fluctuations and phase noise on the performance of low sub-carrier spacing multicarrier mm-wave signals such as those provisioned in the 5G standard. In the third part, two different types of optical frequency comb sources are employed in the optical heterodyne A-RoF link to demonstrate a frequency fluctuation-free mm-wave signal generation. The flexibility of this link is demonstrated by generating multi-frequency mm-wave signals using a single device, while the wavelength flexibility is demonstrated using a wide bandwidth photonic integrated OFC source. In the last part, advanced optical techniques such as active demultiplexing, wavelength reuse and bi-directional signal transmission through the same fibre are demonstrated to assist the efficient expansion of optical heterodyne A-RoF link. The successful demonstration of 5G compatible mm-wave signal generation using a combination of different types of sources and impairment compensation techniques in this thesis makes a strong case for the deployment of optical heterodyne A-RoF link in the next generation millimetre wave wireless systems.