Sony uses an iLink cable to connect to the PC, its pretty much their market on a IEEE 1394 cable.
and as far as really super easy way to get it on your PC and tinker with it, I would recommend Pinnacle Studio 9
Depending on how you acquire the software
-- you'll be paying about $30 for the cable (at BestBuy)
Oh yeah secondly find out what kind of tapes it uses, some of the cameras are a Digital Hi8 which have 520 lines of resolution (same as DVD quality) -- then theres regular Hi8 that has 240 Lines of resolution (VCR Quality) -- Some of the older models that are just Hi8 don't have the ability to transfer to PC.