Shortleg0521,
My antenna is under the deck so I can't examine it. If memory serves, the antenna either screws onto a stud, or has a stud to screw into a female threaded base (a variation of the picture below). Inside of the HD trunk, the AM/FM has it's screw on attachment. You should be able to make a patch cable with screw on connectors on each end. Maybe start with a HD patch cable and modify the other end to attach to the B's mount ? Instead of trying to match up the proprietary Honda clip, try using the threaded mount as a connection point.
Maybe JimmyTee can chime in on how he connected his powered antenna. I don't know if he hooked it up to the Honda OEM head unit or one of his aftermarket units.