Forum Discussion

Kirill Kirill's avatar
Kirill Kirill
Copper Contributor
Sep 01, 2018

MySQL & PowerPivot

When I create a connection to MySQL in PowerPivot and then refresh it through Excel – it’s Ok.

But if I create a connection to MySQL in Excel and then refresh it through Excel – I get an error “The .NET Framework Data provider for OLEDB (System.Data.OleDB) does not support the Microsoft OLE DB Provider for ODBC Provider for ODBC Drivers (MSDASQL). Use the .NET Framework Data provider for ODBC (System.Data.Odbc)”. I have the MySQL ODBC 8.0  driver.

 

How can I create a "full" connection to MySQL in Excel with working refresh option?

 

Thanks

 

No RepliesBe the first to reply