Unable to import a MySQL database from excel

Question

Hello,

I need to import MySQL data, but I have a problem: this type of database is not offered to me.
Here's what I've got:

• From a SQL Server database
• From a Microsoft Access database
• From Analysis Services
• From a SQL Server Analysis Services database)

Normally I'd also have "From a MySQL database", but that's not the case. I've already installed MySQL connect/ODBC and MySQL connect/NET but nothing works.

Do you have a solution?

Thanks in advance

Answer 1

Hi @Eurowatt,

I found this thread **I cant see my mysql database button in excel **which is similar to yours and may help in this case. Have a try to the answer:

After downloading the MySQL Driver from this link as described in this post I can add a new ODBC data source and am able to select the driver. Data -> From Other Sources (last one in drop down) -> From Microsoft Query There select New Data Source and press Ok. In the form you can define a new data source, select the mysql driver etc.

Please let us know if the issue still persists.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.