O'Reilly logo

Gnucash 2.4 Small Business Accounting by Ashok Ramachandran

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action - using popular office software to query GnuCash data

We are going to do two things in this tutorial. First we are going to export the GnuCash data into a SQLite database. SQLite is a popular open source database that is being used behind the scenes in many well-known applications. It is possible that you already use SQLite, though you may not even be aware of that. As a prerequisite to the next step, get an ODBC driver for SQLite3 (http://www.ch-werner.de/sqliteodbc/) or a similar one and install it on your PC. This ODBC driver enables client applications such as OpenOffice.org Base to connect to databases such as SQLite3 as long as both support the ODBC (Open Database Connectivity) standard. After exporting the GnuCash data into ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required