The Columbia Airport is the easiest option for flying in/out of town. It is about a 20 minute drive to downtown, where the hotel room blocks are located.
Another airport option is the Charlotte Airport, with more non-stop options. It is about 1.5 hour drive to Columbia.