mysql for excel

mysql excel export-to-excel mysql-workbench excel-2013
JsEveryDay picture JsEveryDay · Feb 8, 2013 · Viewed 11.7k times · Source

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.

Answer

Kermit picture Kermit · Feb 8, 2013

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.

Related questions

Generating large Excel files from MySQL data with PHP from corporate applications

We're developing and maintaining a couple of systems, which need to export reports in Excel format to the end user. The reports are gathered from a MySQL database with some trivial processing and usually result in ~40000 rows of data with 10…

Read More
How to save MySQL query output to excel or .txt file?

How do you save output of a MySQL query to a MS Excel sheet? Even if it's only possible to store the data in a .txt file, it will be okay.

Read More
How to import an excel file in to a MySQL database

Can any one explain how to import a Microsoft Excel file in to a MySQL database? For example, my Excel table looks like this: Country | Amount | Qty ---------------------------------- America | 93 | 0.60 Greece | 9377 | 0.80 Australia | 9375 | 0.80

Read More