mysql for excel

Question

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.

Comments

[JsEveryDay]

Yeah, I googled it too, no luck. No MySQL for Excel in there.

[JsEveryDay]

I also tried to extract the msi installer and found the installation file but I don't know how to execute it. Cant tell what file format it is.