when doing a odbc lookup everything's fine, but:
using excel as odbc datasource the tables (sheets) are referenced as system tables, not as standard tables.
So they aren't showing up using the database connector.
When trying with MS-Query, there's an option to show these table making them accessible, but there isn't such an option in Switch.
Any idea?
Ralf.
ODBC lookup excel system tables
Re: ODBC lookup excel system tables
Hi Ralf,
I don"t know if your Switch runs on Mac, but if it is the case, this will help you:
If you want to access your ODBC database from Excel: OS X Sandboxing is blocking access to /usr/local
Solution :
1. move the ODBC driver (mysql-connector-odbc-8.x.x-etc folder) from /usr/local/ to /Library/ODBC/
2. Edit the ODBC driver path in the “ODBC drivers” tab of your ODBC manager, change /usr/local/ to /Library/ODBC/
3. recreate DSN
More info: https://community.hortonworks.com/quest ... -hive.html
I don"t know if your Switch runs on Mac, but if it is the case, this will help you:
If you want to access your ODBC database from Excel: OS X Sandboxing is blocking access to /usr/local
Solution :
1. move the ODBC driver (mysql-connector-odbc-8.x.x-etc folder) from /usr/local/ to /Library/ODBC/
2. Edit the ODBC driver path in the “ODBC drivers” tab of your ODBC manager, change /usr/local/ to /Library/ODBC/
3. recreate DSN
More info: https://community.hortonworks.com/quest ... -hive.html
Laurent De Wilde, Solution Architect @ Enfocus