Just your every day run of the mill console doesn't have USB out ... and that is what you'll have to look for, a console with USB out ... then your golden!!
Thats what I use - got one on ebay pretty cheap - (but bought two from ebay that were DOA or screwed up!)
I had an Alesis 8 USB 2.0 but needed more channels
Its a kick ass mixer - I love it
Make sure its the USB 2.0 as the plain USB is only 2-channel not 16 discreet channels of awesomeness...
Comes with Cubase LE 4 which works just fine for me...