Getting to the NEC by train is dead easy, it takes you right there. BUT it is ridiculously expensive so check out the fares first, I am going on the Gundog day and trying to find a reasonably priced ticket from sheffield is proving to be quite difficult. I did think of flying via Berlin..........