Answer the question
In order to leave comments, you need to log in
How to connect MySQL to PowerPivot via Excel so that it is updated?
When I create a connection to MySQL through PowerPivot and then update it through Excel, everything is OK.
But if I create a connection to MySQL via Excel and then update it via Excel, then I get the 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)
<code>
В качестве драйвера использую стандартный "MySQL ODBC 8.0 ".
Как создать полностью рабочее соединение через к MySQL через Excel?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question