Forum Discussion
Kirill Kirill
Sep 01, 2018Copper Contributor
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