Menu
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.
520
Oracle's MySQL for Excel is an add-in for Windows-based Excel. It provides a wizard-like interface for browsing MySQL schemas, tables, views, and procedures, and performing data operations against them in Excel.
In Excel, open the Data tab and choose From Other Sources -> From Microsoft Query. Choose the MySQL DSN. Select the option to use Query Wizard to create/edit queries.
SQL has better data integrity than Excel. Each cell in SQL is limited to only one piece of information—such as day of the week or month. Extrapolating data this way might be a hassle, but it significantly reduces the chance of miscalculations and data errors.
SQL is much faster than Excel. It can take minutes in SQL to do what it takes nearly an hour to do in Excel. Excel can technically handle one million rows, but that's before the pivot tables, multiple tabs, and functions you're probably using. SQL also separates analysis from data.
Looks like this is a known bug:
For now please try the following workaround:
- Launch the MySQL Installer (if already installed launch it from Start Menu > MySQL > MySQL Installer).
- Try to do a Full Installation (but you do not have to actually install them).
- Go to C:\Program Data\MySQL\MySQL Installer\Product Cache
- See if you have there the MySQL for Excel MSI and launch it manually.
I would look these other topics on Google.
60
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
