If travelling from the UK, then Bergerac Airport (EGC) is your best option, with most budget carriers offering a full schedule through the summer months, and a rather limited one during the depths of winter. There are several rental car agencies based at Bergerac airport, too, and the airport is a mere 25 minute drive from Les Terraces. The downside to Bergerac Airport is that it isn’t served by any public (ground) transport links.
The other major airport serving our area is Bordeaux (BOD). It is approximately 1h20m drive (depending upon time of day, and never-ending upgrades to the rocade (ring road)) from Sainte-Foy-La-Grande. There is not (yet) a tram connection into the centre of Bordeaux and the Gare de St. Jean, but there are regular dedicated coach services between the airport and the station.
After a year of renovations, the TER line from Bordeaux to Sarlat re-opened at the end of 2019. In 2020 new, faster, trains are to be introduced, which will reduce the travel time between Bordeaux and Sainte-Foy-La-Grande to about 40 minutes.
If travelling from Paris, the LGV from Paris Montparnasse takes just 2h04 minutes to arrive in Bordeaux, which is pretty amazing (we’ve taken it). If arriving into Charles de Gaulle airport (CDG), one can catch trains stopping at Libourne (the closest main railway station), or Bordeaux.
With SatNav, Google Maps and other applications available in-car (rental, or otherwise), on computer and smart-phone, it feels a little senseless to provide directions to Les Terraces. So we shan’t! However, if using the autoroutes to travel to SW France, the nearest junction to the system north of us is 12 on the A89 at Montpon-Menesterol), while from the south, you want junction 5 of the A62/E72 (direction Marmande).
Driving in Sainte-Foy-La-Grande for the first time can be nerve-wracking: the streets are narrow and one-way, with cars parked seemingly everywhere! Worry not. However, DO be mindful of the fact that in France, unless on specifically designated roads, traffic coming from the right has the right of way. Locals have a tendency to hurtle into junctions at break-neck speed and assume that traffic on the left will stop for them.