You don't want a modem, you want to connect directly to your phone - either via a cable, as the previous poster suggests, or via an infrared or Bluetooth connection if this is supported by your phone and PC.
There's some pointers to information on how to download SMS from the phone here: http://www.traud.de/gsm/index.html
