They make a portable air conditioning unit that sits on the floor. I'm not sure of a model name, but I think I saw one recently at Lowe's or Home Depot.
I don't have an upstairs room, but my room is on the southside of the house. I move my little sewing table and machine to the family room in the hottest part of the summer.