Mysql for excel 64 bit

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.

Table of Contents Show

Your MySQL Data, Your Way!
Bi-Directional Access To Live MySQL Data From Excel
Easy-To-Use, Straightforward Configuration:
Select Tables and Columns
MySQL Data With The Full Power of Excel
Is there a 64 bit version of MySQL?
Is MySQL compatible with Excel?
How do I install MySQL on Windows 10 64 bit?
How do I create a MySQL database from 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.

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

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: https://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

Is there a 64 bit version of MySQL?

MySQL is available for Microsoft Windows, for both 32-bit and 64-bit versions.

Is MySQL compatible with Excel?

Note: MySQL for Excel can return all rows, or a specified range of rows, from a single table only. It cannot import data stored in two different tables, perform table joins, or filter data.

How do I install MySQL on Windows 10 64 bit?

The installation process is similar to other operating systems..

Open the MySQL website on a browser. Click on the following link: MySQL Downloads..

Select the Downloads option..

Select MySQL Installer for Windows..

Choose the desired installer and click on download..

How do I create a MySQL database from Excel?

Within MySQL for Excel, Open a MySQL Connection, click the employee schema, Next, select the location table, click Edit MySQL Data, then choose Import to import the data into a new Microsoft Excel worksheet for editing.