You can't open iPhoto or Aperture? Those are the preferences you want to check. Sometimes the OS won't load the camera as an external drive on the desktop -- you should be able to see it from a photo editing software title.
Also, sometimes computers don't see USB devices if you gracefully, gently plug them in. Don't jam the USB cable in, but make sure it's all one fluid motion and you may have better luck.