Changing cars gearbox from automatic to manual?

Hey,

So the car in question is Honda Accord coupe . (98-01) .. with 3.0 engine. It comes with automatic gearbox only.

Its definitely a car that I would love to buy sometime for a project. But i`m not really very fond of automatics. I do enjoy them occasionally in a newer car. But 3 liter V-tec in such a car - just not really something id like..

So the question is, roughly, how much is needed to be changed ? And how can I find if any gearboxes fit this particular engine ? What should I look at ? Find some codes for engine and gearbox ? And does it even matter ? Has anyone really made any compatibility charts about this ?

I understand its hard work and its costly. I would prefer if you kept these mindblowingly obvious facts to yourselfs, because its not really the question in hand ;) What I want to know, if it`s possible or should I scratch this idea alltogether ?

Thanks in advance