President Carter -- I'm FIRED UP to See Beyonce!!!

President Jimmy Carter has arrived in D.C. for the Presidential Inauguration ... and tells TMZ he's SUPER EXCITED he'll be in the front row when Beyonce performs the National Anthem.