title: Excel table not importing data from properly functioning Access query
body: <p>Alright, I have an Access DB which I am trying to import data from, into Excel. Specifically, I am attempting to import the results of a query which I wrote in Access. </p>
  
  <p>I wrote this query in Access SQL (I have also enabled the ANSI 92 compliant syntax feature in all my Access DB's).</p>
  
  <p>They query isn't any thing too mind boggling. It runs just fine in Access, all the time. No issues with Access. The problem is, that when I add a specific criteria to the <code>WHERE</code>
  clause of my query, the linked Excel file will not import the data. The Excel file just shows a table-ized area with no data.</p>
  
  <p>However, with this criteria removed from the <code>WHERE</code> clause in my query, the linked Excel table is able to refresh just fine, and the table populates with the query results, no-problemo. </p>
  
  <p>Here are pictures of the query: (I drew on the first one with the paint-brush, because it made me laugh, and I am bored in my cubicle)
  <img src="https://i.stack.imgur.com/9K4X3.jpg" alt="enter image description here"></p>
  
  <p>Here is a picture of the Query after the additional criteria is added, which then seems to prevent my Excel table from showing any data from the query results:
  <img src="https://i.stack.imgur.com/p45lN.jpg" alt="enter image description here"></p>
  
  <p>My question is simple, why exactly (in detail, please) does this happen? Is there some sort of query size limit within Excel that I don't know about?</p>
  
  <p>Also, a work-around would be nice, if possible. But I can run the query without this criteria if necessary. I am mainly more interested in knowing the reason behind this issue. </p>