Forum Discussion

Sebastian Dabrowski

Copper Contributor

Sep 14, 2018

How to connect SQL server to Excel in Office 365

After 1.5h on the phone with Microsoft and days spent on online research, I am completely unable to connect MySQL database to my Office 365 database. I seem to have all required details, as I managed...

Sebastian Dabrowski

Copper Contributor

Sep 14, 2018

Hi Jan, thank you for responding.

I'm trying to connect an Excel spreadsheet to an external MySQL database with details below:

Hostname (port no):

176.32.230.48

Database:

cl59-UKHA

I hope that helps.

Sebastian

Silver Contributor

Sep 14, 2018

Do you have the MySQL ODBC driver installed (and the correct version for your OS and for the version of MySQL)? There appears to be one here: https://dev.mysql.com/downloads/connector/odbc/5.3.html

Sebastian Dabrowski
Copper Contributor
Sep 14, 2018
Hi Jan,

I tried installing another connector Microsoft recommended, but that hasn't helped at all. I just installed the one you recommended. What would be the next step?

Sebastian
- JKPieterse
  Silver Contributor
  Sep 17, 2018
  This describes what steps you need to take if you are using Get & Transform (one of the groups on the Data tab of the ribbon) in Excel 365:
  https://support.office.com/en-us/article/connect-to-a-mysql-database-power-query-8760c647-88b9-409d-b312-6ea8f84a269b
  If you want to use the old Microsoft Query, read this article:
  https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
  - Sebastian Dabrowski
    Copper Contributor
    Sep 28, 2018
    Dear Jan,
    
    Thank you very much for your kind reply. I already followed those steps, but nothing has changed. It's also worth to mention that the version of https://go.microsoft.com/fwlink/?LinkId=278885 which is suggested there, is a very old one and not even available any longer.
    
    I can't believe how difficult and complicated it seems to connect SQ to Excel. I'm not sure what to do next to be honest. I tried calling Microsoft, but they asked for £199 to get help.
    
    Sebastian

Resources