Connecting to a MySQL DB through excel

In attempting to connect to a MySQL DB through Excel 2013 I could not find MySQL in;
(1) Data > Get External Data > From other Sources

I then downloaded and installed Power Query but could not find MySQL in;
(2) Power Query > Get External Data > From other Sources
(3) Power Query > Get External Data > From Database

All my internet searching says to use (4) Power Query > Get External Data > From Database but MySQL does not show up in my excel
Any ideas

Attached are the screen shots for (1), (2), (3) and (4)   MySQL-Screenshots.pdf
MichaelQuillDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamCommented:
look at your 4th screenshot it is there.

see circled
1a2aac48-dc55-4ab0-97c6-479acc7d41e3.png
0
Saurabh Singh TeotiaCommented:
MichaelQuill,

In the screenshot that you attached in that first option is SQL Server database..Click on that and it will open a box asking for server name..Just write the server name in their and choose whether you login to that using windows or sql server authentication.. Fill those details and hit next..

In the next screen it will ask you for a schema name of that server...Once you choose the correct schema name it will show you all the tables starting with view of that schema which you can import or work in excel..Select the table and hit next..Their you can decide to give a friendly name and post that you will be good to go as your data will be pulled out..

Another option in power query is using ODBC Driver of SQL which is again the third option of your screenshot you can connect using a ODBC driver if configured in your PC to SQL database...

Saurabh...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MichaelQuillDirectorAuthor Commented:
Hi ProfessorJimJam, That screenshot was included to show what my research on the internet showed. This was not actually what was displayed on my excel.
Thanks anyway

Hi Saurabh, Thanks for suggestions, the first one didn't work but once I install the MySQL ODBC Driver, I followed your second suggestion and that worked.
Thanks
0
MichaelQuillDirectorAuthor Commented:
Thanks for your help Saurabh
0
Saurabh Singh TeotiaCommented:
Michael,

Glad it worked for you..Happy to Help... :-)

Saurabh...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.