[Solved] Calc + UNO + ODBC
Posted: Tue Mar 25, 2008 8:06 pm
OpenOffice.org v2.3.0
Windows XP SP2 Build 2600
In an OpenOffice Calc spreadsheet I have numerous cells which have live data being updated via DDE links to another application. What I want to do is, when a macro is run dump the data into a MySQL database.
The MySQL database is operational on a different host. I have locally installed the MySQL ODBC 3.51 driver, and linked this to my MySQL database. Test connections are successful.
The problem I am having is finding UNO/OpenOffice.org Basic documentation which will enable me to write a macro which will open an ODBC (or direct) link to the database, send it MySQL queries inserting table records, then close the connection.
I have tried some comparable Visual Basic (sorry for uttering that term if it is an f-word around these parts) ODBC code, but the OpenOffice.org UNO interpreter doesn't seem to like some of the object names.
Any help is appreciated!
Windows XP SP2 Build 2600
In an OpenOffice Calc spreadsheet I have numerous cells which have live data being updated via DDE links to another application. What I want to do is, when a macro is run dump the data into a MySQL database.
The MySQL database is operational on a different host. I have locally installed the MySQL ODBC 3.51 driver, and linked this to my MySQL database. Test connections are successful.
The problem I am having is finding UNO/OpenOffice.org Basic documentation which will enable me to write a macro which will open an ODBC (or direct) link to the database, send it MySQL queries inserting table records, then close the connection.
I have tried some comparable Visual Basic (sorry for uttering that term if it is an f-word around these parts) ODBC code, but the OpenOffice.org UNO interpreter doesn't seem to like some of the object names.
Any help is appreciated!