MS Excel connection to MariaDB 10

Third party integrations
1

Hi All,
I’m trying to connect excel to my Home Assistent Database. I sucessfully migrated the hassio database to my synology server running MariaDB 10 and I would like to use Excel to analyze historical data.
MariaDB is running on the NAS (32bit)
Excel is running on a 64 bit Windows 10 machine.
I installed ODBC connector (32 bit) succesfully (I think…) When I test the connection using the powerpivot addon for excel it results in success.
However when I import the database, almost every entry results in

  • ‘success. 0 rows transferred’ and some entries result in
  • '…[10.3.11-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘[schema_changes].* FROM [schema_changes]’ at line 1; 37000.[10.3.11-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘[schema_changes].* FROM [schema_changes]’ at line 1; 37000.

So in the end nothing has been imported.
Any suggestions where to look for errors?

Thanks
PPee

2

This is not an excel or MariaDB forum, I suggest you look at resources for those pieces of software.