How do I upload video from my digital camera to my computer?

Also if you can (heard using a Memory Stick Duo Adaptor helps. Do yo know where I stick the Memory Duo Adapter in my computer?)

Simply plug your camera-supplied USB cable into your computer, and into your camera. Make sure the camera is OFF. Once you have it plugged in, turn the camera ON. If there is an option to put the camera in 'playback' mode, do that.

once the camera is on, wait a few seconds/minutes and a dialog box should appear giving you options of several methods to download the contents from your camera. If there is an option to use a microsoft wizard, choose that option. Follow the wizard and unload the photos and video.

once the video is downloaded, navigate to the folder that the video was placed into, and you should find it there.

get a card reader thats supports memory stick or use the usb cable provided and connect both items

The same as you would upload photos to the computer. One thing though, be sure you got some software like windows media player, or quicktime or realplayer or even nero media player (this is the one i use mostly) preloaded to the computer (free downloads in the internet) so the video from your digicam will work/play properly.

Whatever memory media you have is fine, and using an adaptor is also good.
Most adapters uses the highspeed usb(2.0) port - so you dont go to sleep waiting for the upload be completed. There's no point spending extra bucks for the adaptor when you got the digicam unless you got to transfer from one type of memory to another.
enjoy your videos!