Connect to a database from Excel using JDBC instead of ODBC
Is it possible to connect to a database from Excel using JDBC instead of ODBC? I'm connecting to Teradata from Excel. I can use the ODBC connection but Microsoft updates are causing issues for our users. Our jdbc drivers seem to work flawlessly via other programs. I was wondering if there was a way to connect to a database via a jdbc driver from Excel (VBA?).