conurus
Newbie
Joined: 25 Jan 2007
Posts: 1
Location: Vancouver, Canada
|
 Posted: Thu Jan 25, 2007 3:49 pm Post subject: newbie question on exporting to MySQL |
 |
|
It seems like reading a MySQL datasource into Calc is a lot easier than the other direction, is that true?
Is exporting to csv and importing to MySQL the only way to do it? I really wish to have Calc make a direct ODBC connection to MySQL to do writing (without programming or scripting).
Thanks in advance! |
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Jan 25, 2007 4:45 pm Post subject: |
|
|
To the best of my knowlege, exporting through csv is the most simple way. Some year ago I tried to write a Calc-To-Base tool, but it was not worth the effort. Every spreadsheet cell can have all kinds of values (text, number, date/time, error). The target-table in a database can have many more types, strictly separated by columns. In the end you have to check and convert the data-type of every single cell in each single row before you write the record into the database. Before that, you have to check for the required types in the target table. If you export a new table, you need to check the supported types of it's database-engine. Apart from this, not every spreadsheet is structured like a database-table (fields below headers).
An indirect successor of that project is the SpecialCells add-on, mentioned in the below signature. You may use it for consistancy-checks before exporting to csv. The csv is handled by a mature import tool of your database-engine.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
