Accidentally Removed MySQL For Excel Add-in?

Did you accidentally removed MySQL Excel Add-in for Excel? Are you trying to re-add it but getting errors? In this blog, I try to list some solutions regarding the re-installation of mysql-for-excel-1.3.8. The version of my Windows is 10 and I’m using Microsoft Office 365 16.0.

When you try to reinstall the Add-in, it might not be displayed in the Data tab of your Excel because it’s not properly installed.

Executing MySQL for Excel VSTO File

You can try running the VSTO file in Program Files (x86)/MySQL/MySQL For Excel 1.3.8/MySQL.ForExcel.vsto. It might add the Add-in with no problem. However, you might get the error below.

Name: MySQL.ForExcel
From: file:///C:/Program Files (x86)/MySQL/MySQL For Excel 1.3.8/MySQL.ForExcel.vsto

************** Exception Text **************
System.Deployment.Application.DeploymentDownloadException: Downloading file:///C:/Program Files (x86)/MySQL/MySQL For Excel 1.3.8/MySQL.ForExcel.dll.config did not succeed. —> System.Net.WebException: Could not find file ‘C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.8\MySQL.ForExcel.dll.config’. —> System.Net.WebException: Could not find file ‘C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.8\MySQL.ForExcel.dll.config’. —> System.IO.FileNotFoundException: Could not find file ‘C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.8\MySQL.ForExcel.dll.config’.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
— End of inner exception stack trace —
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.GetResponseCallback(Object state)
— End of inner exception stack trace —
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
— End of inner exception stack trace —
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.DownloadAddIn(TimeSpan timeout)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()

 

Re-Adding or Re-Installing MySQL For Excel

Please follow the steps below to reinstall the Add-in,

  1. Uninstall MySQL For Excel through Control Panel
  2. Open Registry Editor
  3. Search for “MySQL.ForExcel” and delete any record that you find for MySQL for Excel
  4. Restart your computer
  5. Try to reinstall MySQL for Excel Add-in
  6. Open your Excel and hopefully you find MySQL for Excel in your Data tab

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s