Zorg dat de server is geinstaleerd en installeer de (firebird/postgres/mysql) odbc driver
Ga dan naar de odbc administrator en voeg een nieuwe ODBC systeem verbinding toe.
In excel create a new database query.
The flowing screen will appear. Pres the sql button and past the sql below this screen shot to see all transaction input in the database.
SELECT V_TRANSACTASBATCHWITHTRANSID.SREFERENCE, V_TRANSACTASBATCHWITHTRANSID.DDATE, V_TRANSACTASBATCHWITHTRANSID.SACCOUNT, V_TRANSACTASBATCHWITHTRANSID.SDESCRIPTION, V_TRANSACTASBATCHWITHTRANSID.SCONTRAACCOUNT, V_TRANSACTASBATCHWITHTRANSID.STAX, V_TRANSACTASBATCHWITHTRANSID.FAMOUNT, V_TRANSACTASBATCHWITHTRANSID.FDEBIT, V_TRANSACTASBATCHWITHTRANSID.FCREDIT, V_TRANSACTASBATCHWITHTRANSID.FTAXAMOUNT
FROM V_TRANSACTASBATCHWITHTRANSID V_TRANSACTASBATCHWITHTRANSID
Now save the SQL and go to the menu to add a datasource again.
Select import data and select the query you just saved.
The data will be imported and you can see the list in excel.
if data changes you need to refresh the external source.
you can us the data in excel reporting like charts. This way you can create your own view on the osFinancials or Turbocash data using your Favourite tool.