If your camcorder has no mic input, you won't be able to feed audio from an external microphone directly into your camcorder. I've tried numerous times to get an audio signal to channel through A/V Input while recording video... did not work, but it may be different with your video camera. I highly doubt you'll be able to get a USB converter and plug in a digital microphone. Anyway, what do you mean by "active foot". This term is entirely new to me - maybe something that only Sony goers are familiar with.
You'd probably look for an external digital recorder, and then get an XLR to 1/8" adapter if that is what your recorder uses.