P
P
phoenix77712018-09-01 11:08:54
MySQL
phoenix7771, 2018-09-01 11:08:54

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 question

Ask a Question

731 491 924 answers to any question