title: Characters found after end of SQL statement VBA code Access 2007
body: <p>I'm writing a VBA code in Excel to access an Access database.</p>
  
  <p>I'm using this provider</p>
  
  <pre><code>"Provider=Microsoft.ACE.OLEDB.12.0; Data Source= " &amp; DBFile &amp; ";"
  </code></pre>
  
  <p>and here is my SQL string</p>
  
  <pre><code>SQlSrc = "SELECT YEAR FROM Data ORDER BY YEAR ASC"
  SQlSrc = SQlSrc &amp; ";SELECT STN FROM STN_List WHERE include = TRUE"
  </code></pre>
  
  <p>When I open each recordset individualy it works (just first line or second) but when I make as a single statement as above I get an error </p>
  
  <blockquote>
    <p>"Characters found after end of SQL statement"</p>
  </blockquote>
  
  <p>Does anybody have idea if it's a problem with Access 2007?</p>