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.

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)