yeah, the trannys should just bolt right up. I think I remember something about needing the tranny controller, but don't quote me on that.
If it is the tranny, then the motor will rev up and the car won't move forward like it should. If the motor isn't revving up, then the problem is with your motor.
Could be TPS, could be fuel pump, could be a bad/dying coil, could be bad spark plugs, could be out of timing.