LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   Import data from a spreadsheet to a mysql database (https://www.linuxquestions.org/questions/linux-general-1/import-data-from-a-spreadsheet-to-a-mysql-database-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 04:33 PM.