title: How to retrieve data from a SQLite Database in VBA in Excel?
body: <p>I am connecting to the .db file from VBA with ADO following the answer to this <a href="https://stackoverflow.com/questions/42509154/accessing-a-sqlite-database-in-vba-in-excel">question</a>. My code connects correctly but it does not retrieve correct data from the table. In my table i have several columns, the first is INT the second is TEXT and the rest are all INT. </p>
  
  <pre><code>Dim conn As Object, rst As Object
  Dim strSQL As String
  Set conn = CreateObject("ADODB.Connection")
  Set rst = CreateObject("ADODB.Recordset")
  
  
  conn.Open "DRIVER=SQLite3 ODBC  Driver;Database=C:\Path\To\SQLite\Database.db;"
  
  strSQL = "SELECT * from paston"
  
  
  rst.Open strSQL, conn
  
  
  Sheets("sheet2").Range("A1").CopyFromRecordset rst
  rst.Close
  
  
  Set rst = Nothing: Set conn = Nothing
  </code></pre>
  
  <p>The problem is when i select all on the sheet i only the get the first column <code>idx</code>, and if i select only the TEXT column it will not output anything, if i select any other column it will retrieve the numbers as integers but they are longs, </p>