Short answer would be no.
Longer answer would be that it does work with thump drives (usb keys) and the iPhone, but only with pictures.
Check this video out:
[ame=http://www.youtube.com/watch?v=z2qSGel6Jh8&feature=youtube_gdata]YouTube - Apple iPad Camera Connection Kit (Review)[/ame]