Okay I have been searching forums for approximately 3-4 hours now and my question may have been answered but I couldn't find it, so I apologize if it was but please someone could you simply answer yes or no?

I have a 1999 Accord EX SOHC 3.0L VTEC automatic (of course) can I replace transmission with a 97 Accord 4dr v6 auto tranny?

If not what exactly is compatible with my car without converting to manual 6 speed?

Thank you, Thank you, and THANK YOU! I am female and know nothing about cars so please speak slowly.....)