Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?

share|improve this question
add comment

2 Answers

I haven't tried any of the followings. But just sharing with the hope that this may help you...

http://blog.mclaughlinsoftware.com/2011/02/27/excel-2011-query-mysql/ http://blog.mclaughlinsoftware.com/microsoft-excel/excel-2011-mysql-config/

Source: http://forums.mysql.com/read.php?171,561930,561930

FYI, MySQL officially introduced a tool namely MySQL for Excel (for Windows) to work with Excel.

MySQL for Excel allows you to work with a MySQL database from within Microsoft Excel. MySQL data can be imported into Excel, Excel data can be exported into MySQL as a new table or appended to a current table, and MySQL for Excel allows you to edit the MySQL data directly from within Excel.

share|improve this answer
add comment

Save it as .csv and then use the mySQL CLI [or other client-side utility] to issue a LOAD DATA LOCAL INFILE statement.

share|improve this answer
    
Agree 1000% using 3rd party software for this type of activity is bound to complicate things more than it needs to. –  Pynner Nov 17 '12 at 1:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.