This is the software that the professionals should have included with the cameras we bought.
Just bought my first digital camera, a Canon G3, and tried various tools for viewing and downloading pictures until I found cam2pc. It's really the best, congratulations!
Once I had configured cam2pc to do what I wanted it to do (automatically download, rename and store photos according to date) it became one of those how-did-I-manage-without-it programs. Definitely much better than the software that was bundled with my camera, and it integrated well with my existing image editing software.