Import data from a spreadsheet to a mysql database
Linux - GeneralThis forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
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.
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)
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.