LinuxQuestions.org

LinuxQuestions.org (http://www.linuxquestions.org/questions/index.php)
-   Linux - General (http://www.linuxquestions.org/questions/forumdisplay.php?f=1)
-   -   Import data from a spreadsheet to a mysql database (http://www.linuxquestions.org/questions/showthread.php?t=749290)

deostroll 08-21-2009 08:38 AM

Import data from a spreadsheet to a mysql database
 
Hi. Is there any way I can import data from an OpenOffice spreadsheet file into a table in mysql. Does mysql have the provision to open and query spreadsheet files on linux.

PS: I currently use the centos machine.

MBybee 08-21-2009 06:00 PM

I'd do one of two things, depending on how often you need to do this:
1) Export the file as CSV and import
2) Use the MySQL connector (described here: http://forge.mysql.com/wiki/Connector_OpenOffice)


All times are GMT -5. The time now is 10:39 PM.