Category: Uncategorized

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

 

Small businesses can win competition by collaboration.

Many small businesses are creative, efficient and provide flexible solutions. However, they feel weak in competition with larger businesses. They do not have as much funding as larger corporations for branding and marketing. Or do not have enough resources to grow their business.

What are the potential solutions to help small businesses to gain strength in competition?

I work for a Custom Web Application Development company who is pursuing collaboration as a winning tool. Each small business has strengths that covers the weakness of other small businesses.

For example, we are helping a junk removal company in promoting their business. They are good in removing construction junk and we are good in tech such as website development, and digital marketing. This company does not have enough funding and resources to compete with larger junk removal companies. But with the power of collaboration, more opportunities will be available to win. We both benefit from this collaboration.

We encourage small businesses to collaborate together and create opportunities for each other. We can’t compete with larger companies without helping each other.

But how if our small business turns to a larger company. Would we forget our values in empowering small businesses?