You don't say where in the upstate you live. I lived in Greenville for 15 years and it had plenty of gamers then and probably still does, now. I know the scene has changed since I moved, but check with the stores in the area. Also check with Borderlands, better known for comic books but they also handle a lot of Games Workshop stuff and host games.
I have to second Firefly Games in Lexington, it is a great store. But it might be a drive from Greenville. They have things going on each night. The big nights are Friday and Saturday, but I go on Tuesday, which is a much quieter night.