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 //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.
asked Feb 7, 2013 at 23:32
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.
answered Feb 7, 2013 at 23:35
KermitKermit
33.4k13 gold badges83 silver badges120 bronze badges
2
This bug is fixed as of MySQL for Excel 1.2.1. However, due to the nature of this bug, you must manually uninstall previous versions of MySQL for Excel before installing v1.2.1+.
answered Jun 17, 2014 at 22:53
Philip OlsonPhilip Olson
4,4321 gold badge23 silver badges20 bronze badges
I faced the same problem. You can download the mysql_for_excel standalone .msi file here: //dev.mysql.com/downloads/windows/excel/
After that copy the .msi to C:\Program Data\MySQL\MySQL Installer\Product Cache and execute it. Restart the excel. Done
Then in the Data tab you can see this
answered Apr 5, 2018 at 15:38
PSNPSN
2,0963 gold badges26 silver badges51 bronze badges
I have a same problem in Mysql 8.0.17 and the Mysql for excel not showing in the data tab, after install and uninstall several time finally found the problem in the adds-in for user of my windows. You must open the excel app by [open as administrator] Mysql for excel appeared after this.
answered Jul 16, 2020 at 22:08
TofiqTofiq
2,6266 gold badges24 silver badges34 bronze badges
Your MySQL Data, Your Way!
The Excel Add-In for MySQL provides the easiest way to connect with MySQL data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live MySQL tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.
Bi-Directional Access To Live MySQL Data From Excel
The Excel Add-In for MySQL is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.
Easy-To-Use, Straightforward Configuration:
- Install the Add-In
- Login with User & Password
- Select Tables
Installing any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.
Select Tables and Columns
Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live MySQL Data.
MySQL Data With The Full Power of Excel
Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
- Modify and delete Records.
- Quickly export and backup data.
- Operate on data with Charts and Pivot Tables.
Building custom dashboards & reports that connect with live MySQL data has never been easier. Download the CData Excel Add-In for MySQL Server now, and get connected.
Download Now