Is is possible to import a sql query into a table within access without using a linked table / ODBC connection? In excel you can create an ODBC connection and free form SQL query into the connection so you only pull in the data you need. I am trying to import from a corporate SQL server, but there is way too much data to import everything or link the table. I'd like to include some where clauses in the import using ODBC.