OK. The background first:
Sony stopped support for the camera a few years after it was introduced. This is not untypical; Sony's support period for products is two to three years. It was last supported under Windows XP, which means that it is now about 10 years out of support. The 32-bit software originally supplied with it will not run under Vista, Windows 7, Windows 8 or Windows 8.1. Therefore you need a workaround.
There are two possible workarounds and I think one is more convenient than the other, but you will have to judge which one you like better. Both converge at the actual process of transferring the pictures.
1: Buy a USB universal flash memory reader so you can transfer pictures without having to plug in the camera and keep it attached with the power on. Cost, a few dollars. Two typical units on ebay are linked below.http://www.ebay.com/itm/321756363690http://www.ebay.com/itm/391023218481
I think that this is more convenient because you simply eject the Memory Stick from the camera, insert it into the reader, and transfer the photos at your convenience without having the camera powered up and tethered to the computer.
2: Tether the camera to the computer by USB cable and use it as the card reader, per the instructions on page 82 of the user manual. If you don't have the user manual, you can obtain a copy at the link directly below.https://docs.sony.com/release/MVCFD200.pdf
Here the instructions converge.
With either the card reader attached or the camera tethered, look in My Computer for a disk drive that is labeled a Removable Disk. If the camera is tethered there should be only one. If a card reader is used there may be five and you will have to look in all of them to see which one is the Memory Stick reader.
From here forward we consider the camera / card reader to be a removable disk drive and treat it as such.
Navigate to the folder on the drive that contains the pictures. Leave this window open. We will call this Folder 1.
Open another copy of Windows Explorer or My Computer and navigate to the folder to where you want the pictures to go on your computer's hard drive. We will call this Folder 2.
Click in the Folder 1 window. Press CTRL and A
at the same time, then CTRL and C
at the same time. This puts all the photos on the Clipboard.
Click in the Folder 2 window. Press CTRL and V
at the same time. This copies all photos to Folder 2.
Now the photos are on your hard drive and you can do whatever you wish with them.
If you are using the card reader, replace the Memory Stick into the camera.
Do not erase the photos from the camera until you are sure they were copied successfully.
Let me know if these instructions are sufficiently detailed. If so I will write them up so you can download a printable copy.