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