Reading *.mny using DBeaver (SQL tool) RRS feed

  • General discussion

  • Recently, I was able to use DBeaver (an SQL tool) to open and read the *.mny file. With that.  there is a now another path to query data from *.mny using standard SQL syntax - making it possible to export data for additional report (or export to another personal finance program).

    The bad news is that it is not straightforward process. For example, it is not that obvious to do something like: query all my expense for last month. At minimum, one will have to guess:

      * the right table

      * columns in that table (some column are obvious, other are not)

      * some column values are of 'bitmask' style (if bit 1 is on, then something is enable)

    So obvious this is not for everyone but if you have some technical background, this is might be of interest.

    http://dbeaver.jkiss.org/download/ (the SQL tool)

    http://ucanaccess.sourceforge.net/site.html (the JDBC driver)

    http://jackcess.sourceforge.net/ (Java library for reading from and writing to MS Access databases )

    When I have time, I will add a cheat-sheet on  how to stitch all the above parts together.


    Saturday, January 14, 2017 5:37 PM