title: How to append data from an Access table to a SQL server table via a pass-through query?
body: <p>It seems like it's only possible to use a <strong>pass-through query</strong> to retrieve data from your SQL Server tables and into MS Access. But how about the other way? From an Access table to a SQL server table.</p>
  
  <p>What are my options from within MS Access when I need high performance? <BR><em>(The normal approach of having an append query that appends to a linked table is simply <strong>too slow</strong>)</em></p>
  
  <p>In an pass-through query I cannot reference MS Access tables or queries, and therefore my INSERT INTO statement cannot work. Is there a work around via VBA?</p>