i have a 97 acura cl, it has a 3.0 v6 vtec (j30a1)

its tranny went out, so i got one out of a 99 accord, everything bolted up and it drives just fine, but i dont have a speedometer, or a place to to put the vss. the hole is plugged. since this trans obviously doesnt work, which tranmission from another honda will? no salvage yards have a transmission at a decent price around here and im on a budget.

which transmissions out of which cars will work? thanks in advance,.