I want to show how to use OpenOffice.org with the odbc connection to mmex DB.
1. Add two representations of your database, as described here: viewtopic.php?f=12&t=533
2. You must install SQLite ODBC Driver from here: http://www.ch-werner.de/sqliteodbc/
3. Then you can configure odbc connection: Control Panel-Administrative Tools-Data Sources (ODBC)-user DSN-Add.
Select from the list SQLite3 ODBC Driver.
Data Source Name: My connection 2009
Database Name: C:\Users\Me\budget2009.mmb
The values of other fields can not be changed.
4. Run OpenOffice Base. Steps: 1 Select Database:Connect to an exiting Database: ODBC. [Next].
2.Select OBDC Connection [Browse] Choose "My connection 2009" [Finish]
Save "New Database" to any folder that you wish.
5. Choose Tables, Right Click on alldata, Database, Properties. Additional Settings: Charicter Set: Unicode (UTF-8) [OK]
6. Choose Queries, Create Query in SQL View...
Copy/Past the code:
- Code: Select all
select a.AccountName, a.id, a."Date", a.Amount, c.currency_symbol,
a.Category, a.Subcategory, a.notes
from alldata a left join currencyformats_v1 c on a.currencyid=c.currencyid
order by a."date" ,"a"."id"
Run query to check the reseved data is OK. Then save the Query as Query1. Menu:file-close.
7. Now Right Click on "Query1" in the OpenOffice.org Base window and choose Copy
8. Past the data from clipboard to an OpenOffice.org Calc.
9. The END
Addition info: http://wiki.services.openoffice.org/wik ... Office.org
PS As a result, you can get excellent csv file for import into another program, for example.