=ImportHtml("http://the-url-goes-here", "table", 0)
My first attempt was scraping some fantasy football points projections:
=ImportHtml("http://www.fftoolbox.com/football/2011/cheatsheets.cfm?player_pos=QB", "table", 0)
Bingo. At least, it worked for me on the 8 pages I tried. I used 0 as the third argument because some web page recommended it.
I could see using this for data scrapes when a small number of pages are involved, but for more advanced scrapes that require automation I'll continue to use R.