Tranny Swap? Can it be done??

Man,im officially lost! But maybe you guys can help!! I want to swap my transmission from an AT to an MT on my 94 Accord, but I keep hearing it would never happen. I asked my friend and he said I could just take the transmission from another honda and have an engine shop install it for me. Then I had another friend that said you can do anything with my transmission but buy a new car altogether. I kinda know it would cost $$$ like from getting parts and fabrication, but if I know it can be done i'd ultimately go for it. What can I do!?!?!?