title: How to create temp tables in SQL Server via MS Access
body: <p>I have an ODBC connection to SQL Server. I need to process data within Access, but it takes too long. My idea is to push this data to a SQL Server temp table and have SQL Server do the processing. I have many pass-through queries in my Access database but do not know how I can create a temp table from Access to SQL Server. Is there a way to do this using either a query or VBA code? </p>