OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

newbie question on exporting to MySQL

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
conurus
Newbie
Newbie


Joined: 25 Jan 2007
Posts: 1
Location: Vancouver, Canada

PostPosted: Thu Jan 25, 2007 3:49 pm    Post subject: newbie question on exporting to MySQL Reply with quote

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!
Back to top
View user's profile Send private message Visit poster's website
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Jan 25, 2007 4:45 pm    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group