I'm actually surprised that Microsoft has not yet made a "skydrive" drive in explorer that natively and seamlessly integrated with this service.
From a perception standpoint, I hesitate to use this because it seems that MS doesn't yet have full faith in this service.
Skydrive explorer [http://skydriveexplorer.com/index.php] offers integration with Windows Explorer
Thanks for the link. I also went out and found this one
which offers mountings for google docs, picasa and a bunch of others...
You probably want Windows Live Mesh if that's why you're looking for.
It's like Dropbox, but a bit more complicated/flexible, has more free storage, can sync any folder on your system, does p2p syncing, works through firewalls without configuration, etc.
The SkyDrive still needs a native client to be as useful as DropBox, but it's a step in the right direction.