Microsoft Access 2010 - Select directly from and ODBC source table

select

      *

from

      [ODBC;DSN=ODBC_DNS_NAME_HERE;].[TABLE1]

;