Forum Discussion
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...
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
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
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
- Perhaps this gives some pointers?
https://forums.totalchoicehosting.com/topic/17162-database-query-from-excel-to-mysql/
or this one:
https://stackoverflow.com/questions/19448205/excel-vba-connecting-to-remote-mysql-databaseThank you Jan, I'll try those.