Most cameras nowadays will allow you to download its contents via a USB, Firewire or even thorough its memory card. Though your computer will need to have a memory card reader to be able to read the card and then download its contents to your computer HDD.
Interesting fact is that, some video cameras will already come with a USB cable attached to itself, so all you have to do is connect to your computer USB port.