title: Importing SQLite3 data into Excel 2010 (via Microsoft Query and ODBC driver)
body: <p>I'm trying to load <strong>SQLite3</strong> database data into <strong>Microsoft Excel 2010 x32</strong> via Microsoft Query (in <strong>Microsoft Windows 10 x64 Creators Update 1703</strong>).</p>
  
  <p>I downloaded and installed the <strong>SQLite ODBC Driver 0.9996</strong> from <a href="http://ch-werner.de/sqliteodbc/" rel="nofollow noreferrer">http://ch-werner.de/sqliteodbc/</a>. Microsoft Excel 2010 runs as Win32, so I've tried both variants - Win32 driver only and Win64+Win32 drivers.</p>
  
  <p>I've opened Excel, then go to <strong>Data</strong>-><strong>From other sources</strong>-><strong>From Microsoft Query</strong> (the last item)
  <a href="https://i.stack.imgur.com/N5DCp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N5DCp.jpg" alt="enter image description here"></a></p>
  
  <p>Then I select <strong>SQLite3 Datasource*</strong>
  <a href="https://i.stack.imgur.com/Q59X6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Q59X6.jpg" alt="enter image description here"></a></p>
  
  <p>and set path to my database (I don't select any addtitional checkboxes)
  <a href="https://i.stack.imgur.com/qyGcR.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qyGcR.jpg" alt="enter image description here"></a></p>
  
  <p>After that first strange thing appears - table list is empty:
  <a href="https://i.stack.imgur.com/ZNtUM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZNtUM.jpg" alt="enter image description here"></a></p>
  
  <p>To fill the list I have to uncheck and the check again <strong>tables</strong> checkbox under <strong>parameters...</strong> button
  <a href="https://i.stack.imgur.com/HtQru.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HtQru.jpg" alt="enter image description here"></a></p>
  
  <p>And then tables are shown correctly as I've expected
  <a href="https://i.stack.imgur.com/wmCa8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wmCa8.jpg" alt="enter image description here"></a></p>
  
  <p>And then the main problem comes out: when I select <strong>only one table</strong> from list - data is loaded correctly
  <a href="https://i.stack.imgur.com/wUGMd.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wUGMd.jpg" alt="enter image description here"></a></p>
  
  <p>but if I select <strong>several tables</strong> - no data is loaded (looks like some problem with joining tables)
  <a href="https://i.stack.imgur.com/CsdYn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CsdYn.jpg" alt="enter image description here"></a></p>
  
  <p>So is this ODBC driver still working in Microsoft Windows 10 x64 (and for Microsoft Excel 2010 x32)?
  Or maybe I'm missing some additional checkboxes?</p>
  
  <p>P. S. I've uploaded my test SQLite3 database here - <a href="https://yadi.sk/d/aO0zDSof3Tz2FY" rel="nofollow noreferrer">https://yadi.sk/d/aO0zDSof3Tz2FY</a></p>