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
