The new accord does have a manual on the V6. I have no clue if they work/match/or are even swappable, but it won't be cheap, becuase it's only the new cars that come with one. Probably around $2000 for the transmission plus all the parts and work, if it even fits. way too much.
it wont work..a whole different generation. errr i just had to get the car that was hard to fix. dammit.