Search code examples
mysqlexcelexport-to-excelmysql-workbenchexcel-2013

mysql for excel


I am not sure if this is the right place to ask this question but I am facing an issue with MySQL installed failing to recognize office 2013 and install MySQL for Excel.

Basically MySQL https://dev.mysql.com/downloads/

Has an addin for excel that allows you to automatically connect to a database and make changes. During the MySQL installation it checks for requirements, one of which is Excel 2007 or greater. And that requirement is not met for me. I am running Office 2013 Pro Plus (64bit) and Installing MySQL (64bit)

Can someone help? Is there any other application that you recommend? I dont want to import and export data or files manually. I need an application that opens all the tables in separate sheets that I can manually change and automatically save to the DB.

Any advice appreciated.


Solution

  • Looks like this is a known bug:

    For now please try the following workaround:

    1. Launch the MySQL Installer (if already installed launch it from Start Menu > MySQL > MySQL Installer).
    2. Try to do a Full Installation (but you do not have to actually install them).
    3. Go to C:\Program Data\MySQL\MySQL Installer\Product Cache
    4. See if you have there the MySQL for Excel MSI and launch it manually.

    I would look these other topics on Google.