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)
|All times are GMT -5. The time now is 11:22 PM.|