Yeah, I knew about CS3/4 and it's weird 'anti-twain' stance. (ie you can make CS3/4 work, but only in 32 bit mode, iirc - anyhue, it's bloody bonkers)
And yes, there is software that will scan it (and you can program it to automatically scan to a directory by pressing a button on the scanner as well)
Just make sure you buy it from my site / amazon - that way I get a teeny tiny kickback, another four sales and I might get an £20 amazon voucher! woohoo!
-pj