Calc- data sync to mysql. Is it possibe?

[ant75]

Hi

I’d like to create a libreoffice sheet which uses datas from mysql database, so reads and write it…
Is it possible ?? If yes, how ?

[Wanderer]

This method described in another thread is also working with MySQL.

View #base `.odb` file in `.odt` file as OLE object?

menu:View>Data sources… [Ctrl+Shift+F4] Drag a query or table icon from the left pane into the document. No, this won’t be an OLE object.

So register your MySQL database first, then use it as above.

[Villeroy]

Writing from Calc to Base is not possible because Calc has no column types. It is possible to attach database forms to Calc sheets.
See Apache OpenOffice Community Forum - [Solved] Using Filter in Calc V3.1 with dates - (View topic)