title: Extracting Day Books / Transaction Data from Tally using ODBC
body: <p>I am able to successfully connect Excel to Tally ODBC Server using Microsoft SQL Query. I now want to extract all transaction data for entire history into excel (including debit and credit ledgers) like in a Day Book. However, if I extract using <code>CompanyVouchers</code> table, I only get the data for current date in Tally, and only for single ledger.</p>
  
  <p>STEPS FOLLOWED:</p>
  
  <ol>
  <li>Open Microsoft Excel on your computer.</li>
  <li>Click Data > Get External Data > From Other Sources > From Microsoft Query</li>
  <li>Select TallyODBC64_9000*</li>
  <li>Select CompanyVouchers from the Query Wizard</li>
  </ol>