Just using the table will open it up in the client memory space, so yes, it will move the whole table.
You could access these tables through an ODBC connection and a view and limit the number of records that way.
Insanity: Doing the same thing over and over and expecting different results.