Hotel
We have a few rooms blocked off here; however there are many hotels, Airbnb, and VRBO options in downtown Columbia.
Flight
The closest airport is CAE, which is located about 15-20 minutes from downtown Columbia and probably the most convenient option. CLT (Charlotte) is about 1.5 hours away from Columbia, but is a much bigger airport and there may be more flight options.
Travel Note
Uber and Lyft are both active in the area. There are taxi cab companies if preferred.