How to add MYSQL to Excel Addins

Can anyone tell me if MYSQL and MYSQL FOR EXCEL is the same ?
I work extensively with Excel and yesterday downloaded and installed MYSQL
from the Community site using Installer.
If it is then how do I add MYSQL to the addins in Excel ?
Many thanks
Ian
raceproretiredAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
Ian

Apologies, it's been some time since I last installed MySQL.

Try this link instead, it should install both MySQL and MySQL for Excel among other things you might be interested in , e.g. MySQL Workbench.
0
 
Tahir QureshiSystem AnalystCommented:
once you have install mysql for excel it will show in data tab

please see the video about how to use addin

https://www.youtube.com/watch?v=E_kn71R9BL0&ab_channel=MySQL
0
 
raceproretiredAuthor Commented:
Is MYSQL and MYSQL FOR EXCEL the same ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Tahir QureshiSystem AnalystCommented:
MYSQL FOR EXCEL is just an addin
it will let you connect to Mysql server
0
 
NorieVBA ExpertCommented:
Ian

No they aren't.

MySQL for Excel is an add-in for Excel that you can download from here.

It will allow you to work with MySQL databases, so you would also need to install MySQL.

Here's a link to the community edition of MySQL, MySQL Community Server.
0
 
raceproretiredAuthor Commented:
I think that's the link I used but nowhere in the installation does it show MYSQL FOR EXCEL
How can I tell if it is installed ? I don't see any add-ins in Excel
The above video that Tahir posted was one I saw earlier but it shows the Add-in already shown
in the ribbon.
Any further help appreciated
Thanks
Ian
0
 
raceproretiredAuthor Commented:
That's the link I used.
How can I know it is downloaded correctly ?
There was no sign of MYSQL FOR EXCEL in program features
nor in the APP menu or the Excel Add-in menu
0
 
raceproretiredAuthor Commented:
I have managed to find the link for MYSQL FOR EXCEL and downloaded and installed it. It shows
in Programs and features. I had to download/install Visual Studio Tools for Office runtime.
However it doesn't appear in the Excel addin menu.
0
 
raceproretiredAuthor Commented:
I managed to install successfully after downloading other files. Restarting and
ticking .com box in Excel add-in
Thanks to both
Ian
0
 
NorieVBA ExpertCommented:
Ian

Glad you got it working, was at work earlier so couldn't check my own MySQL installation.

PS Was going to suggest checking under COM Add-ins but that's locked down at work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.